On Demand Subreport Page Footer

[Former Member]

Hi,

I have a on-demand subreport. It doesn't show page footer for every page, instaed, it shows only one page footer at the end of the report.

How can I see page footer for every page in the report?

Thanks.

[former_member260594 · Accepted solution]

John,

You may want to create a hyperlink to an existing report rather than use an on demand subreport. The target report can then contain Page Footers.

[Former Member]

Hi John,

Subreports do not have page footer, need to create a fake page footer.

Below is the Kbase article which explains how we can create fake page footer:

How to create fake page footers in subreports

Symptom

In Crystal Reports (CR), subreports do not contain page footers. How can you create a fake page footer for a subreport?

Resolution

To create fake page footers in subreports you need to insert and format a second Details section and a second Report Footer section. These sections will act as page footers.

Before You Begin

-

---

You must decide how many records you want per page. The number of records must be static, as must the fields. The 'Can Grow' option cannot be selected for any fields. It is also recommended that you have a static number of groups per page.

The following example creates ten records per page in the Details section without any groups.

Create Fake Page Footers in a Subreport

-

---

1. Right click the gray area to the left of the Details section and then click 'Insert Section Below'. You will now have a 'Details a' and a 'Details b' section.

2. On the 'Report' menu, click 'Section Expert'.

3. Click 'Details' (not 'Details a' or 'Details' b) and then click the 'X+2' button next to 'New Page After'. Insert the following formula in the 'Format Formula Editor':

Remainder(RecordNumber, 10) = 0

Click the 'Save and Close' button.

(This ensures the subreport will have 10 records per page. Change the second argument of the Remainder function in every formula to the number of records you want to see per page.)

4. In the Section Expert, click 'Details b' and then select the 'Print at Bottom of Page' check box. Then click the 'X+2' button next to 'Suppress (No Drill-Down)'. Insert the following formula in the 'Format Formula Editor':

Remainder(RecordNumber, 10) <> 0

Click the 'Save and Close' button.

(This makes the 'Details b' section appear at the bottom of each page, every tenth record.)

5. In the Section Expert, click 'Report Footer a' and then select the 'Print at Bottom of Page' check box. Then click the 'X+2' button next to Suppress (No Drill-Down). Enter the following formula in the 'Format Formula Editor':

Remainder(RecordNumber, 10) = 0

Click the 'Save and Close' button.

6. Click 'OK' to close the Section Expert.

7. Insert fields and other objects that you want in the fake page footer into both the 'Details a' and 'Report Footer a' sections. Format these two sections so that they are identical.

When the report is previewed, the subreport will have ten records per page with the 'Details b' section at the bottom of each page acting as the page footer. If the last page has less than ten records, the 'Report Footer a' section will act as the page footer instead.

Hope this helps!!!

Regards,

Deepti Bajpai

[Former Member]

Hi John,

Subreports contain only report footer but not page footer. It is by design. As a work arround create a formula like

whilereadingrecords;

true

and insert a group on this formula and go to group options and check the option "repeat group header on each page" this works as a page header in subreport.

Regards,

Raghavendra