Am using crystal report 8.5 version..i have an rpt which uses a subreport.

 

Here in the main report am using a filter for from date and To date via Edit selection formula....

 

So in the subreport also i need to filter the records using from date and to date.is there any way to add the main report paramter(fromdate & todate) to the subreport also?

 

Thanks,

Neha.

 

 

Save the main report with a different name say summary sub with the fields you want to display in the subreport.

 

Then do the following

1)Open the main report.

2)Insert Subreport select the saved subreport.

3)Right click the subreport and select change subreport links.

4)In subreport links dialog In available fields select the from and to date parameter of main report and move to Fields to link to list box

5) Then from select data in subreport based on field select the date field  from subreport.

6) once done open the subreport in design mode and you will something similar

 

{CALENDAR.CREATE_DATE} = {?Pm-?From date}
and
{CALENDAR.CREATE_DATE} = {?Pm-?To date}

 

please change the = to sign >= and <=

 

The above settings were based on Crystal version 9 , maybe the settings are different in version 8.5 so please check

 

Cheers

Rahul