| :: Date manipulation / If else checks in the reports :: (2) | Post a New Message | Post a Reply |
 Date manipulation / If else checks in the reports | Post a Reply |
since: May 10, 2005
from: El Dorado Hills, CA
I have a specific sets of reports we are building for a customer. The single record in the SQL SERVER table looks like
Yards Start Date End Date Number of Days
----- ---------- -------- --------------
1000 10/01/2005 10/04/2005 4
I need the ASPReportsWizard to divide the Yards by Number of days and generate the data for 4 days as follows
On Start Date 10/01/2005 report, 250SY
On Start Date 10/02/2005 report, 250SY
On Start Date 10/03/2005 report, 250SY
On Start Date 10/04/2005 report, 250SY
Any pointers on how we can accomplish this, will be very helpful.
 Re: Date manipulation / If else checks in the r... | Post a Reply |
from: Laurel, MD
[sql][/sql] tags in your TextReplacement to perform processing within your database. e.g. [sql]Yards/NumberOfDays[/sql] will return the Yards divided by the number of days -------------------------
Master of the Game