[dba-SQLServer] Re Numbersand crystal reports

Create the table on the fly as a CTE, or if you are working with an older version of sql server, as  derived table.


Message: 5
Date: Wed, 24 Mar 2010 22:03:11 -0500
From: "Jeff B" <jeff.developer at gmail.com>
Subject: Re: [dba-SQLServer] (cross posted) Looking for some Crystal
        Reports help
To: "'Discussion concerning MS SQL Server'"
        <dba-sqlserver at databaseadvisors.com>
Message-ID: <4baad14a.5744f10a.5ede.30b8 at mx.google.com>
Content-Type: text/plain;       charset="iso-8859-1"

Sorry, should have been a little clearer.  I cannot create additional
tables, this is a 'closed' system.  I need this to be as hands-off as
possible as I will not be there after this week.  So far everything works
fine except for printing the correct number of labels.

Jeff Barrows
MCP, MCAD, MCSD
?
Outbak Technologies, LLC
Racine, WI
jeff.developer at gmail.com


The contents of this e-mail message and its attachments are covered by the Electronic Communications Privacy Act (18 U.S.C. 2510-2521) and are intended solely for the addressee(s) hereof. If you are not the named recipient, or the employee or agent responsible for delivering the message to the intended recipient, or if this message has been addressed to you in error, you are directed not to read, disclose, reproduce, distribute, disseminate or otherwise use this transmission.  If you have received this communication in error, please notify us immediately by return e-mail or by telephone, 530-893-3520, and delete and/or destroy all copies of the message immediately.