Skip to Content

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.

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

    1. Nirupa Nalabotula 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.

      (0) 
      1. sriram santharaman

        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 .

        (0) 
  1. Huynh Nhung

    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.

    (0) 

Leave a Reply