How to: Crystal Subreport Multipage Headers

Crystal Reports, by Seagate Software, is a report writing and generating software application that runs within the Microsoft Windows environment. Crystal Reports allows the user to create or alter an original report. It can also generate a new report by gathering and assimilating data from multiple databases using Open Database Connectivity and Active X. There is no direct way to display page headers on every page of a subreport in Crystal Reports, but it can be done and the fix is fairly simple.

Instructions

1. Enter this formula to the options for sorting and grouping records:

   WhileReadingRecords;
   " "

   Give the formula a name and enter it into the drop-down menu options for sorting and grouping records.

2. Bring up the "Insert Group" dialog box. In the top drop-down menu look for, and select, the name you gave the formula. In the bottom drop-down menu, select the option “In ascending order.”

3. Click on the "Options" tab at the top of the "Insert Group" dialog box. At the bottom of the box, check the box next to "Repeat Group Header on Each Page." A group is added to your subreport.

4. Type the desired text of your header in the "Group Selection" area for your subreport, .Click "OK."

References

• Whatis Techtarget: Crystal Reports
• C Sharp Corner: Tip: How to Add a Page Header to a Subreport in Crystal Reports: Mahesh Chand