Print all dates in a year

[jnujella]

How can I make a report to print all dates in a year from today's date???

I want to use this in my cross tab report.

Thanks for any help.

 

[Madawc]

The simplest way is to get a date table set up, if that's possible.

Failing that, I can't see any simpler way than 366 separate definitions, to allow for each year including leap-years. That also would not allow crosstabs, everything would need to be repeated as a 'mock-crosstab'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[kskid]

What version of Crystal are you using? With Crystal 11, I have used an Excel spreadsheet with my dates and left outer joined the remaining tables. I believe prior to Crystal 11, you could not have mixed datasources on the same report.