Skip to Content
Author's profile photo Nikhil Sabnis

How to let a Cross-Tab grow vertically?

When we create a cross-tab report in Crystal Reports, which shows a lot of data, will usually span multiple pages horzontally. The below steps will make the cross-tab grow vertically:

1. Let’s consider we have sample data as below:


2. Create a cross-tab based off this data with “Date” field placed in the Rows section, the “Store” field in the Columns section and the “Amt” field in the Summarized Fields section of the cross-tab expert.

3. Under “Customize Style” section of the cross-tab expert check the options (Uncheck all other check boxes):

    a. Suppress Row Grand Totals

    b. Suppress Column Grand Totals

    c. Keep Columns Together

    d. Column Totals on Top

4. Click Ok. This should create a cross-tab as below:

Original Cross-Tab.JPG

5. The scree-shot in the point No.4 is an example of the cross-tab spanning multiple pages horizontally.

6. In order to let the cross-tab grow vertically, we will create a group and will decide how many columns we should show in each group.

7. Now to the base data, shown in Step 1, add another column named “GrpCnt” and number the rows which you want to be shown in each group. Ex. Let’s suppose we want to show 5 columns in each group. Then enter value 1 under the GrpCnt field for first 5 data rows, value 2 for next 5 dta rows and so on. Please refer the snap-shot below:

Updated Base-Data.JPG

8. Now in our report do “Verify Database” to let Crystal Reports add the new “GrpCnt” column to the report.

9. Create a new group based on the column “GrpCnt”.

10. Suppress the Group Header1 and place our cross-tab, built in previous steps, in the Group Footer1 section. Keep some space at the top of the cross-tab to separate each instance of the cross-tab from each other.

11. Refresh the report and we are done. Refer the snap-shot below:

Updated Cross-tab.JPG

Assigned Tags

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

      Alright, so this was the workaround you mentioned when we spoke about this sometime back.

      Smart...and you'll always be a Champ Sir!


      Abhilash Kumar

      Author's profile photo Nikhil Sabnis
      Nikhil Sabnis
      Blog Post Author

      Thanks Abhilash!!

      Author's profile photo Former Member
      Former Member

      Nice one Nikhil and thanks for sharing 🙂

      Just curious if we can still embed a summary and/or a calculated member that spans multiple groups.

      One of the issues I was working in the past had similar design, just that there was a separate Cadre-Code field instead of GrpCnt.



      Author's profile photo Former Member
      Former Member

      Amazing workaround.....


      Author's profile photo Former Member
      Former Member

      Awesome Solution

      Author's profile photo hu po
      hu po


      But I have a question: if group is 1~3, and 4~6, and 7~9...and so on...

      how to write a formula?


      Author's profile photo Huynh Dung
      Huynh Dung