I have a report that is a collage of 5 subreports which are mixed with commands and tables internally. The report produces a result of records based on todays date minus 1.
Current Date -1=yesterday.
I need to have the report scheduled in BOE to normally run as scheduled with the default date always accepting the Current Date minus 1 so that it looks at yesterdays data. I need the option to say if the report needs a look back at the data from 10 days ago I need the report to be flexible so that the user can pick a date without changing the design of the report just picking a different date.
I assume I would use a parameter and I could somehow set the date default to be always today? How do I do that?
If I am using SQL commands for many of the subreports in the Add Command window should I build the Parameter in the Add Command or in Crystal Reports Designer itself? The report takes seven minutes to run as is?