Passing value from subreport to higher section

[shera4111]

Hi all,

I'm building a report that is pretty much a bunch of subreports one after the other, with an agenda style list at the start. What I'd like to do is note on that first page (the agenda), which page of the report the subreports start on. For example:

Agenda:
1) review Report1 - see page 2
2) review Report2 - see page 6

Kicker, for those who know about passing shared variables b/w subreports and main, is the fact that the value of the shared variable (in this case the page number), must appear BEFORE the subreport, because the agenda must be the first page.

Basically the report is set up like this:
ReportHeader a
-Agenda listing
ReportHeader b
-SubReport1
ReportHeader c
-SubReport2

I thought I could just put the two subreports in sections above RHa (above the agenda) and then supress them. But it seems Crystal doesn't evaluate supressed subreports.

Anyone know if there's a way to do this? Alternate ways are welcome, if there's no way to trick Crystal into evaluating a shared variable in a higher section...

Thx,
shera4111

 

[IdoMillet]

There's a somewhat awkward method described at:

http://support.businessobjects.com/library/kbase/articles/c2011950.asp

If you are willing to accept output as a Crystal export to PDF, consider a 3rd-party solution. See list of 3rd-party tools at:

http://www.kenhamady.com/bookmarks.html

My "Visual CUT" software can add a table of contents (and re-number the pages to adjust for the fact that the Table of Contents occupies one or more pages) to pdf exports from Crystal.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com