Subreport in Main Report

Hi Ramco.

I also faced this issue like, but I used C# and Crystal Report.

In Crystal Reports, page numbers are typically controlled by the main report's page footer section. However, when you have subreports, the page numbers may behave differently in each subreport.

To address the issue of the page number being printed only on the last page of the subreport, you can try the following steps:

Check Page Footer in Subreports: Ensure each subreport's page footer section is properly set up. The page number should be placed in the page footer section of each subreport.
Page Numbers in Main Report: Ensure that the page number field is placed in the page footer section of the main report. This is the section where page numbers are typically controlled.
Subreport Pagination: Check the subreport's properties to ensure that it's set up to paginate correctly. Right-click on the subreport in the main report and choose "Format Subreport" or "Change Subreport Links." Ensure that the subreport is set to a new page or set up in a way that accommodates the page numbering.
Evaluate Section Order: Ensure that the sections in your main report are in the correct order. Sometimes, placing a subreport in a specific section might affect how it interacts with the page numbering. Make sure that the sections are logically ordered.
Grouping: If you're using grouping in your main report, make sure that the page number is placed in the correct group footer or group header section.
Suppression: Check for any suppression conditions on the page number field or the sections that might prevent the page number from being printed on every page.
Preview the Report: Preview the report and check the behavior in the Crystal Reports designer. This may help you identify any specific sections or subreports causing the issue.
Page Number Format: Verify the format of the page number field. Sometimes, if the format is set to appear only on the last page, it might lead to the described behaviour.

If the issue persists, you may need to provide more specific details about your report structure and settings for a more accurate troubleshooting guide.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramco Ramco2y ago
Hi Mayooran

In Subreport Page N of M is in report footer when i click edit SubReport from main Report. when i open Subreport directly then it shows in Page Footer.

Thanks
Mayooran Navamany2y ago
Hi Ramco.

I also faced this issue like, but I used C# and Crystal Report.

In Crystal Reports, page numbers are typically controlled by the main report's page footer section. However, when you have subreports, the page numbers may behave differently in each subreport.

To address the issue of the page number being printed only on the last page of the subreport, you can try the following steps:
1. Check Page Footer in Subreports: Ensure each subreport's page footer section is properly set up. The page number should be placed in the page footer section of each subreport.
2. Page Numbers in Main Report: Ensure that the page number field is placed in the page footer section of the main report. This is the section where page numbers are typically controlled.
3. Subreport Pagination: Check the subreport's properties to ensure that it's set up to paginate correctly. Right-click on the subreport in the main report and choose "Format Subreport" or "Change Subreport Links." Ensure that the subreport is set to a new page or set up in a way that accommodates the page numbering.
4. Evaluate Section Order: Ensure that the sections in your main report are in the correct order. Sometimes, placing a subreport in a specific section might affect how it interacts with the page numbering. Make sure that the sections are logically ordered.
5. Grouping: If you're using grouping in your main report, make sure that the page number is placed in the correct group footer or group header section.
6. Suppression: Check for any suppression conditions on the page number field or the sections that might prevent the page number from being printed on every page.
7. Preview the Report: Preview the report and check the behavior in the Crystal Reports designer. This may help you identify any specific sections or subreports causing the issue.
8. Page Number Format: Verify the format of the page number field. Sometimes, if the format is set to appear only on the last page, it might lead to the described behaviour.
If the issue persists, you may need to provide more specific details about your report structure and settings for a more accurate troubleshooting guide.