PremHealth1
MIS
HI, I'm using Crystal Reports 2016 connected to SQL Server.
Part 1
I made a simple that looks like this...
Part 2
Then I grouped by Procedure Code and get this...
Part 3
So my preview pain looks like this...
Part 4
Then I added a summary of Insurance Payments at the Report footer level so my preview pain now looks like...
In the above in Part 3 or Part 4 a user can drill on ABC or DEF to open a new tab that will display the related detail rows from Part 1. What I want the user to be able to do is drill on 6,350.00 in Part 4 so a new tab displays that shows all detail rows for all Procedure Codes (all detail rows from Part 1).
While researching this I saw a post stating that you can't put a drill on a Report Footer object. That made me think the only way to do this is add a sub-report (hopefully an On-Demand sub-report). My intent was to pass all the detail data from the main report to the sub-report without having the sub-report query the database again.
- I attempted to create an on-demand sub-report multiple times but all I could ever get was the last row from Part 3 to display.
- I attempted to use shared variables but again same kind of problem.
Is there a way to do this without running a second query?
Thanks!
Part 1
I made a simple that looks like this...
Code:
Page header row in design mode: Procedure Name Procedure Code Insurance Payment
Detail row in design mode: Hip Replacement ABC 50.00
Detail row in design mode: Hip Replacement ABC 100.00
Detail row in design mode: Hip Replacement ABC 200.00
Detail row in design mode: Broken Arm DEF 1000.00
Detail row in design mode: Broken Arm DEF 2000.00
Detail row in design mode: Broken Arm DEF 3000.00
Part 2
Then I grouped by Procedure Code and get this...
Code:
Page header row in design mode: ...row is suppressed.
Group header row in design mode: ...row is suppressed.
Detail row in design mode: ...row is suppressed.
Group footer #1 row in design mode: Group #1 Procedure Code Insurance Payment
Report footer row in design mode: ...row is suppressed.
Page footer row in design mode: ...row is suppressed.
Part 3
So my preview pain looks like this...
Code:
Group footer #1 row 1 in preview mode: ABC 350.00
Group footer #1 row 2 in preview mode: DEF 6000.00
Part 4
Then I added a summary of Insurance Payments at the Report footer level so my preview pain now looks like...
Code:
Group footer #1 row 1 in preview mode: ABC 350.00
Group footer #1 row 2 in preview mode: DEF 6000.00
Report footer row 3 in preview mode: 6,350.00
In the above in Part 3 or Part 4 a user can drill on ABC or DEF to open a new tab that will display the related detail rows from Part 1. What I want the user to be able to do is drill on 6,350.00 in Part 4 so a new tab displays that shows all detail rows for all Procedure Codes (all detail rows from Part 1).
While researching this I saw a post stating that you can't put a drill on a Report Footer object. That made me think the only way to do this is add a sub-report (hopefully an On-Demand sub-report). My intent was to pass all the detail data from the main report to the sub-report without having the sub-report query the database again.
- I attempted to create an on-demand sub-report multiple times but all I could ever get was the last row from Part 3 to display.
- I attempted to use shared variables but again same kind of problem.
Is there a way to do this without running a second query?
Thanks!