cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Categories and Multiple summaries

Former Member
0 Kudos

Environment: Crystal Reports 2008 on Oracle database

We have a requirement to have a crystal report showing summarized (total count) values for different categories in a single report. However the catch is that groupings for different categories are different.

For example,

Site -


>Ringaskiddy

Total risks at the site----


>25

Mitigated risks----


>23

Unmitigated risks----


>2

Number of users with risks----


>9

Mitigated users----


>8

Non-mitigated users----


>3

Number of user-risk combination----


>35

Here, for the u201CTotal risks at the siteu201D summarized values, the groupings needed are SITE>Users>RISK LEVEL>RISK>PERMISSION>PERMISSIONRISK and for the u201CMitigted risksu201D summarized values, the groupings needed are SITE>Users>RISK LEVEL>RISK-->MITIGATION.

Also, on clicking the summarized values, the report should drill down with respective groupings accordingly.

One approach, we are thinking is to have different sub-reports for each category and click the summarized values to open the corresponding sub-report. However, the question is that whether we get the summarized values of the sub-report to get displayed in a parent report.

Please let us know if anyone has any pointers to solve this requirement.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...