SAP Crytal Report

How to create Cross Tab Layout in Crystal Reports?. The Complete SAP Crytal Report Developer Course 2023 [Videos].

Cross tab is used to display the data that is grouped or totaled in two directions. It shows data in a compact format, which makes it easier to understand and see the trend in the data. For example, if you want to see the quantity sold by the customer in a particular region, without cross tab, it shows the data in a spread-out form.

Cross Tab

You can add multiple number of attributes in rows and columns by clicking on "+" sign. To delete an object click on X sign.

Cross Tab Layout

When you click on Insert, cross tab adds to the Structure of the report. If you click on the page tab, it will show Cross tab data in the report.

You can also edit the cells in cross tab. To edit Cross tab properties, right click on Cross tab and you can change the properties −

  • Format Cross tab
  • Edit Cross tab
  • Sort
  • Hide
  • Grid Options
  • Pivot
  • Create chart from cross tab

Cross Tab Properties

A Crosstab includes row totals, column totals and grand totals. To see values as percentage, right click on Total cell and go to Format Total → select show as percentage.


Grid options allow you to do formatting of cross tab rows like hiding empty rows, repeat row labels, hide row grand totals, etc. as shown in the following image.

Grid Options

See All

Comments (354 Comments)

Submit Your Comment

See All Posts

Related Posts

SAP Crytal Report / Blog

What is Crystal Reports ?

SAP Crystal Reports is a Business Intelligence tool which is used to generate reports from both SAP and non-SAP data sources. It enables end users to generate reports that includes exceptional visualizations and implement new business requirements into reports to reduce dependency on IT and Report developers.
7-Feb-2022 /17 /354

SAP Crytal Report / Blog

What is GUI Navigation in Crystal Reports?

Crystal Reports for enterprise provides an interface that enables you to quickly and easily create, format, and publish effective reports. The menu bar provides full range of features available in Crystal Reports for Enterprise as shown in the following image.
7-Feb-2022 /17 /354

SAP Crytal Report / Blog

What is Options in Crystal Reports?

Report Options is one of the most commonly used feature in Crystal Report Designer, when you need to access/modify the values of Report Options of a Crystal report at runtime in a Crystal Reports .NET application.
7-Feb-2022 /17 /354