Does anyone know if it is possible to force a subreport to wait to run until after the records for the main report have been read (or printed) in Crystal 2011? The quick explanation of what I am doing is this:
I am trying to calculate a running total whose value is then used to link a subreport to the main report. The subreport has to be in the page header, but the running total doesn't return a value until the bottom of the first page (or at least after the details section). So, the subreport is blank on the first page, since it doesn't have a value to use to link it to the main report (or it tries unsuccessfully to link with a NULL value, maybe).
I did try EvaluateAfter({?Pm-#running_total}) at the beginning of the report record selection formula in the subreport (the subreport links), but that didn't work.
If this is too vague, I would be happy to be specific. I just thought maybe there was a known way to regulate evaluation times for subreports without needing details about my specific situation.
Any insights would be appreciated.
thanks, jc
I am trying to calculate a running total whose value is then used to link a subreport to the main report. The subreport has to be in the page header, but the running total doesn't return a value until the bottom of the first page (or at least after the details section). So, the subreport is blank on the first page, since it doesn't have a value to use to link it to the main report (or it tries unsuccessfully to link with a NULL value, maybe).
I did try EvaluateAfter({?Pm-#running_total}) at the beginning of the report record selection formula in the subreport (the subreport links), but that didn't work.
If this is too vague, I would be happy to be specific. I just thought maybe there was a known way to regulate evaluation times for subreports without needing details about my specific situation.
Any insights would be appreciated.
thanks, jc