A surprising behavior observed when I was experimenting with the Section Expert in Crystal Reports.

It doesn’t sounds logical, however if you require printing a blank page after every set of group in Crystal Reports this is the most simplest way that I have come across.

1.       Create a report with a group in it

2.       Now insert a field in the details section

3.       Now the formatting starts,

4.       Click on Report Menu >> Section Expert

5.       Select Details Section >> Paging Tab >> Select Landscape Radio Button >> Click OK

Now

6.       Select Group Header >> Paging Tab >> Select Landscape Radio Button >> Click OK

The default setting for other sections remains default for paging.

Note: With such formatting every alternate page will have a different page size. A blank page will appear only if the rest of the sections do not contain any data.

Now if you need to print Group Header on a different page and data under it on next page. Example: you want the group name to appear like a page cover and the rest data on other page then this is how you can achieve it.

Click on Report Menu >> Section Expert

Select Details Section >> Paging Tab >> Select Landscape Radio Button >> Click OK

The default setting for other sections remains default for paging.

May be there could be some more ways through which all this could be achieved but this was something really easy and different that I came across.

To report this post you need to login first.

1 Comment

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

  1. Nebojsa Stefanovic

    Hi Sayyed,

    In this comment, I will explain the reasons for the current behavior, some problems with the solution, and finally propose a better solution to the problem.

    Reason for the current behavior:

    Each time there is a Landscape section followed by a Portrait section (or vice versa), we have to go to the next page – as 2 modes cannot mix on a single page.

    In your case, this is the order of sections (with their orientations) and where page break will happen as a consequence of page orientation:

    Group Header (L)

    Details (L)

    Details (L)

    Details (L)

    >>>Page break

    Group Footer (P)

    >>>Page break

    Group Header (L)

    Details (L)

    Details (L)

    Details (L)

    >>>Page break

    Group Footer (P)

    >>>Page break

    Group Header (L)

    The problems with this solution:

    1.     Report author is choosing orientation in order to create page breaks and NOT to specify how pages should look like. In this particular case, all other areas (group footers, page header/footer, report header/footer) will be shown in Portrait – probably something that the report author would not like.

    2.     This is a non-intuitive solution as you pointed out (and this can lead to problems in maintaining the reports)

    A proposal for a better solution”

    1.     Go to Section Export

    2.     Go to Details and Paging tab.

    a.     Choose New Section and click on Formula button

    b.     Write the following formula “next({Table.Column_A}) <> { Table.Column_A }

    (where Table.Column_A is a column that you are grouping on)

    3.     Go to Group Footer and Paging tab

    a.     Select “New Page After”

    4.     Click OK.

    (0) 

Leave a Reply