Crystal Reports in the Real World—OLAP Summary Report with Drill-down

The scenario discussed here describes the flexibility behind accessing multidimensional and relational data sources in one report. The benefit of this type of functionality is to enable the user to see aggregated information coming from a cube while allowing drill-down on the relational data to provide greater detail. By using parameters in this report you let the user decide which information elements are displayed.

1.
Start by creating a simple sales report against the sample Xtreme data source. For the data, select the Customer table. Group the Report by Region, City, and then Customer. Hide the City and Customer groups and enable drill-down on these sections. The report ...

Get Special Edition Using® Crystal Reports® 10 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.