Skip to Content
Author's profile photo Former Member

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.

Main Report Structure.jpg

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.

Main Report Headers.jpg

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.

Sub Report Structure.jpg

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.

Sub Report Headers.jpg

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.

Page Break.jpg

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.

Page 1.jpg

Page 2.jpg

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.

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Abhilash Kumar
      Abhilash Kumar

      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member

      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 .

      Author's profile photo Former Member
      Former Member

      Thanks for sharing.. Good keep it up 😉

      Author's profile photo Former Member
      Former Member

      It was a nice note Nirupa. 😎

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Thanks for Sharing

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Huynh,

      Can you elaborate about the requirement that you mentioned above.

      Author's profile photo Former Member
      Former Member

      Thanks Nirupa Nalabotula,

      Now, I'm using Format with multiple columns to resolve it 🙂

      Author's profile photo Former Member
      Former Member

      How to suppress duplicate rows