Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Date Parameter values to SubReport w/both evaluat separately

Status
Not open for further replies.

RoMarcus

MIS
Oct 16, 2007
45
US
I am trying to select records based on a date range to display on the main report and a subreport with both reports reporting off of different tables. I have two parameters on the main report to make a date range ?startdate and ?enddate - I made two formulas that share these for the subreport -->@start and @end. The main report is using these fields in the header so I think they are working right. (I've also tried to place them in the group headers, footer, and details sections to help troubleshoot this)
I'm trying to get the subreport to do the same date range selection based on a different table but using the same date range. I'm able to share to the @start and @end dates into the subreport (the fields are displaying) but I am unable to select the data based on those fields (I've also placed these fields in the header and details sections). In the SELECT I'm getting the " This formula cannot be used because it must be evaluated later" error message. Thank you.
 
Choose Edit > Subreport Links. Link the parameters, rather than some associated field. That should work OK.

Note that you will have to link to some field in the subreport, and that a selection based on this will be placed in the subreport record selection. You can change it within the subreport if that is not what you want.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

What I said is true for 8.5 and 10, and probably the others.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Thanks - I did figure this out just before I received this notification and this does seem to be working properly now.
Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top