views:

42

answers:

2

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
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