Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Pivot Tables in Crystal Reports?

I need to make a pivot table on my Crystal Reports. Right now i'm using an ODBC connection...but while I know you can create a pivot table in CR, I am not 100% sure how to do it. Anybody here know an easy step-by-step way to do this?

like image 725
yeahumok Avatar asked Oct 28 '09 19:10

yeahumok


People also ask

What is crosstab in Crystal report?

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.

Can you do pivot tables in Salesforce?

You can create a pivot table when you want to explore and extract data. For example, you can get sends and open rates for all your emails so you can see how well a specific email performed. After you create a pivot table, you can export it locally or create a scheduled report.

Can grow in crosstab Crystal report?

Cross-Tabs, like Charts, are always able to grow. For this reason, the "Can Grow"-related formatting options are disabled. It really wouldn't make sense if they couldn't grow since they are dynamic objects.


1 Answers

Within Crystal Reports go to File/New and choose Cross-Tab Report. Setting up the data connection and links are the same as a standard Crystal Report, and you simply add the fields that you require into the columns and rows boxes on the Cross-Tab set up screen. If you are familiar with Pivot tables/cross-tab reports then this should be fairly straightforward.

like image 54
Dusty Avatar answered Oct 17 '22 00:10

Dusty