Page numbering and Subreports 1

[wavecruzin]

I am using Crystal 9 and have a main report that has two sub reports in the report header (one in report header a and one in report header b). Both of my subreports have groupings and only have charts. How can I create page footers for each of my subreports that will precede the numbering for the main report?

 

[synapsevampire]

Right click each report header and select section expert and select reset page number after.

-k

 

[wavecruzin]

I want my page numbers to be continuous. Will that happen with the technique you mention. For example if my subreport has 3 pages and it is located in the report header of my main report, I want the first page of my main report to start on page 4.

 

[synapsevampire]

Then you don't need to do anything, the nature of page numbering is continuous.

Perhaps I'm missing something here?

-k

 

[wavecruzin]

Currently I don't have a page footer in my subreport. If I put one in the subreport and the subreport is in the report header of my main report will the page numbering precede the page number that is in my main report page footer? For example, say my subreport has three pages. Will those page numbers be numbered 1, 2, and 3 and the first page of my main report be numbered 4?

 

[synapsevampire]

Try it.

Don't worry over page headers/footers in the subreport, they don't work anyway, the main report page footer will be operable and hence the page numbering is driven by it and continuous.

-k

 

[wavecruzin]

Current I don't see any page footer on the subreport pages. The page numbers only start showing on the main report. Should I be seeing page numbers on the subreport pages. The subreport is in my report header of my main report.

 

[lbass]

Actually, you need to use the page footer of the main report which is not available to the report header. So I think you will need to create a formula that includes all records like:

//{@all}:
whilereadingrecords;
1

Insert a group on this, remove the group name and then insert a second group header section. Place your subreports in these group headers and suppress the report header section. Then use the main report page footer for your page numbering. In the section expert format GH1a and GH1b to new page after and reset page number after.

-LB

 

[wavecruzin]

Is there any other solution than making a group. I would prefer not to see the group value in when previewing the report. Also will this work with multiple page subreports?

 

[lbass]

No, not unless you have the option of using the report footer instead of the report header for the subreports.

You should be removing the group name from the group. If you are referring to the group tree, you could name the grouping formula something that looks like a header for the tree, e.g., if your report groups on countries, rename {@all} so that it reads {@Countries}. Then the group tree will make sense to the viewer.

-LB

 

[wavecruzin]

Thanks for your help.

If I change this:
//{@all}:
whilereadingrecords;
1

to

//{@countries}:
whilereadingrecords;
1

My group value in the previewer is still 1. However if I
change the formula to

//{@all}:
whilereadingrecords;
"Countries"

then the group value is Countries. That works. Is that what you meant?

Thanks again for your help!

 

[lbass]

No, that isn't what I meant, but after testing I see that it is the value that appears in the group tree, not the formula name, which I should have realized. Good job on making the necessary change!

-LB