CR8.5 (and CE8) with an Oracle DB
Long description, small problem:
I have a bar chart that is based on a group. When I click on one of the bars I get another bar chart that provides the details of the parent bar. This is not done using a subreport, but by placing the child chart in the group footer and hiding it. Works great.
I also have a link at the top of the my report that opens an on-demand subreport. The subreport is the same grouped data, but displayed as a parent pie chart with drill-down pie pieces. Again, works great.
I do not want to display the bar chart when a particular parameter (let's say "x") is selected, so I conditionally suppress all the sections that contain the bar chart information, including the on-demand subreport. I have placed a copy of the subreport in another section but not as an on-demand subreport (and is suppressed when "x" is NOT selected.) The result is that when "x" IS selected, the bar chart is hidden and the parent pie chart is displayed automatically. Still on track.
The problem comes in when the user selects "x", then wants to drill down into the pie pieces. The parent pie chart is being displayed in the Preview window, but when the user clicks on one of pie pieces, the entire parent chart is opened again in a subreport tab, THEN the user can drill into the pieces. It's not a huge problem, it's just really confusing to the user to have to "open" the parent pie chart twice before drilling into the detail. This doesn't occur when the user opens the pie chart as an on-demand report.
I thought that non-on-demand subreports were embedded into the master report, so I shouldn't have to "open" the subreport to get to the detail. Is this just a quirk with subreports or is there something I can do to bypass that 2nd click?
Thanks!
Jen
Long description, small problem:
I have a bar chart that is based on a group. When I click on one of the bars I get another bar chart that provides the details of the parent bar. This is not done using a subreport, but by placing the child chart in the group footer and hiding it. Works great.
I also have a link at the top of the my report that opens an on-demand subreport. The subreport is the same grouped data, but displayed as a parent pie chart with drill-down pie pieces. Again, works great.
I do not want to display the bar chart when a particular parameter (let's say "x") is selected, so I conditionally suppress all the sections that contain the bar chart information, including the on-demand subreport. I have placed a copy of the subreport in another section but not as an on-demand subreport (and is suppressed when "x" is NOT selected.) The result is that when "x" IS selected, the bar chart is hidden and the parent pie chart is displayed automatically. Still on track.
The problem comes in when the user selects "x", then wants to drill down into the pie pieces. The parent pie chart is being displayed in the Preview window, but when the user clicks on one of pie pieces, the entire parent chart is opened again in a subreport tab, THEN the user can drill into the pieces. It's not a huge problem, it's just really confusing to the user to have to "open" the parent pie chart twice before drilling into the detail. This doesn't occur when the user opens the pie chart as an on-demand report.
I thought that non-on-demand subreports were embedded into the master report, so I shouldn't have to "open" the subreport to get to the detail. Is this just a quirk with subreports or is there something I can do to bypass that 2nd click?
Thanks!
Jen