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 Total risks at the site summarized values, the groupings needed are SITE–>Users–>RISK LEVEL–>RISK–>PERMISSION–>PERMISSIONRISK and for the Mitigted risks 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.
v_ji (BOB member since 2009-06-09)