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?
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With