Troubleshooting Parameters in Crystal 8.5

[nubianqueen]

Hi,
I'm trying to create a crystal report and the data source is two linked SQL views. I need a parameter that asks for the start date and ending date. The field that I'm trying to use is a date field on a linked subreport in crystal. When I run the report I do get a prompt to enter these dates but the report is still returning all records. I'm not sure why that is. I hope this makes since to someone. Any assistance will be greatly appreciated.
Thanks

 

[synapsevampire]

Create a date parameter in the subreport, and make sure that you select Range.

In the subreport, add something like the following to the Report->Edit selection formula->Record:

{table.date} = {?MyDateRange}

Now the report will prompt and limit the rows in the subreport.

-k