I've created a few calendar style reports. To do this I created a single column table called calendar_date. There are no keys. It's just a single column table with values that begin with January 1, 2011 and increment daily for several years (e.g. all the way to December 31, 2018). When I link this table to the other tables in my database (on a date field) and then run the report it takes 25 minutes to run each time - because the table is not indexed, I understand.
Instead of using a standalone, non-indexed calendar_date table to achieve the calendar style reporting is there a function (or something) in Crystal that can accomplish the same thing, in effect? That way the report can run quickly.
Edited by: mahewitt on Jan 31, 2012 3:54 PM