Crystal Reports in the Real WorldAdvanced Cross-Tabs


Although a single Cross-Tab that covers all the data in a report can be quite useful, with some large datasets it can be quite unreadable. A simple solution to this is to group the report and place the cross-tab in the group header or footer. Cross-tabs are context sensitive and if placed in a group header or footer will show only data for that group.

1.

Using the skills described in earlier chapters, create a new report from the Xtreme Sample Database. Add the Customer table to the report, group the report by country, and remove all fields but the Country field in the group header. See Figure 10.16 to see the report's starting point.



Figure 10.16. Report framework.


2.

From the Insert menu, choose Cross-Tab. Add the Cross-Tab to the Group Header. Right-click on the Cross-Tab and select the Expert. From the list of available fields, select Customer Name and add it to the Rows window of the Cross-Tab. Select the Region and add it to the Columns window. Select Last Year's Sales and add it to the Summarized Fields window. Check your work against Figure 10.17 for accuracy.

Figure 10.17. Building the cross-tab.


3.

Click OK to close the Cross-Tab expert. In Figure 10.18, we see the complete report.

Figure 10.18. Grouped cross-tabs can avoid confusion through improved readability.


4.

Save the report as GroupedCrossTab.rpt.




Crystal Reports XI(c) Official Guide
Crystal Reports XI Official Guide
ISBN: 0672329174
EAN: 2147483647
Year: N/A
Pages: 365

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net