Crystal Reports with different columns on each page in Enterprise Version
In this document, creating different columns on a new page is shown in step by step process.
1. Create a report with the fields/objects required to be displayed on 1st page by dragging the objects from ‘Result Objects Browser’ onto the body section of the report (Here I have taken Name, Column 1, Column 2, column 3 objects). By default header labels will be created in the Page Header section, select all the labels and drag them into the body section as shown in below image.
2. Insert a sub report in the Report Footer section of the report as shown in below image.
3. Select all the Header Labels by selecting CTRL Button->right click->General->Check ‘Hide If Duplicated’ as shown below, so that headers will not be repeated for each record.
3. Double click on the sub report that was inserted in Report Footer. Drag the required fields/objects that need to be displayed on the 2nd page of the report (Here I have taken Name, Column 4, Column 5, Column 6, Column 7 objects) and move the header labels onto the body section as we have done in step 1 as shown in below image.
4. Select all the Header Labels of sub report by selecting CTRL Button->right click->General->Check ‘Hide If Duplicated’ as shown below, so that headers will not be repeated for each record.
5. again come back to the Structure pane of Main Report and select the Report Footer->right click->check ‘Page Break Before’ option. Now after the body section, this entire Report Footer will be displayed on 2nd page, so the sub report inside this section also gets displayed in 2nd page of the report.
6. Below shown is the report output in the Page mode. You can see the Page 1 and Page 2 in below images which is our required output.
In this way we can display different columns in different pages in a single crystal report by inserting few more sections inside the “Report Footer” section containing sub reports for each section.
Thanks, Nirupa. if you only want the Column headers to appear on one page (the first) page, you can place them in the Report Header.
-Abhilash
Hi Abhilash,
Yes even you are right. That is bit easy process also. But if I place the Column headers in Report Header section as you said, they will be displayed on top of the Page Header i.e., above the Report Title, Header separation line and Date as I gave in my report which does not look good.
Dear Nirupa ,
Nice Article , But your using header label in Body , Just split Body section in to (A,B), so that u can paste header label in Body A , . Also Check suppress Blank space for Body A , so u can avoid space between Labels and Data's . It will Be easy for who learning from this article .
Thanks for sharing.. Good keep it up 😉
It was a nice note Nirupa. 😎
Thanks for Sharing
With your reccomemded, the entire Report Footer second will be displayed after the entire of report footer first will be displayed.
How about if I want they will show come each other, the report footer second will intermix with the report footer first ?
Page 1: report footer 1
Page 2: report footer 2
Page 3: report footer 1
Page 4: report footer 2
...
until the entire both of them will showed.
Hi Huynh,
Can you elaborate about the requirement that you mentioned above.
Thanks Nirupa Nalabotula,
Now, I'm using Format with multiple columns to resolve it 🙂
How to suppress duplicate rows