I am trying to create a crystal report. Is there a way in which I can create a report that prints the results when someone first selects a specific period of time (may be in a combo box) for which it should produce the reports.
A:
Sure, you can create parameters for your report, in this case date parameters.
You should then be able to use the Record Selection Formula editor to use these parameters, such as:
{Table.DateField} >= @DateFrom AND {Table.DateField} <= @DateTo
LittleBobbyTables
2010-07-01 23:04:23
A:
You can use the following suggestions;
1- You can follow LittleBobbyTables suggestion by passing two parameters to report and use Record Selection Formula to filter report data.
2- You can set report datasource to a StoredProcedure which takes two parameters (in your case: DateFrom & DateTo), and make report filteration in databse (I prefer this solution from Performance point of view).
Ahmed
2010-07-02 12:56:32