Write your query to return:
Month (as number), Day (as number), other data
order by Day, Month
Then loop through the result and each time the month is < the last
month
start a new row.
Justin
-----Original Message-----
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 4:06 PM
To: CF-Talk
Subject: What is best way to write this report?
I've got a query that returns a date and a sales figures for the
previous
365 days. I need to write this information to a report in the format
of:
Jan 1 Feb 1 Mar 1 Apr 1 May 1 ...
Jan 2 Feb 2 Mar 2 Apr 2 May 2 ...
Jan 3 Feb 3 Mar 3 Apr 3 May 3 ...
Jan 4 Feb 4 Mar 4 Apr 4 May 4 ...
On to the end of the days in the month.
>From an architectural stand point, what is the best way to do this?
Paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
