on 06-17-2010 9:52 AM
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.
Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.