Show all dates between Start and end Dates 1

[gillf]

CR9 (off SQL via ODBC): In my database I have a Start and End date. Can I can get the report to show all the individual dates in that range, even if the 'between' dates are not stored in the database? For example, with a Start date of 1st Jan 2005 and End date of 5th Jan 2005, I want to display 1st, 2nd, 3rd, 4th and 5th.

 

[IanWaterman]

From what you are saying each record has 3 date fields, one showing current date and the other showing static start and end dates?

You can create either a Date Range Parameter or two date parameters for start and end.

These are then used in you select statement to filter dates required, the data is then sorted by the currentdate field.

Ian Waterman
UK Crystal Reports Consultant

 

[gillf]

Not quite the problem - I have two dates in my data: Start Date and End Date for work on a Contract.
I want the report to return a record for every date between them - I suppose I am asking Crystal to CREATE a range of sequential dates between any two given start and end dates. I hope this is clearer?

 

[campsys]

Take a look at FAQ 767-4532

"Creating data for dates not in the data set with SQL Server SQL to create a Periods Table"
faq767-4532

http://www.tek-tips.com/faqs.cfm?fid=4532

 

[gillf]

Thanks very much, campsys. That should keep me quiet for a bit!