Crystal Reports: ? Possible to show Full Set in one chart, and subsets in separate charts?

In Crystal Reports, is there a way to get both full set charting and subset charting, in the report headers?

I'm working on a report from an erstwhile co-worker and I'm still trying to make things "better".

While I haven't found the solution to accruing time ( see Accruing over time (non-overlapping) - technique? )

I'll press on with how to use the resulting data once I retrieve it.

The report is a Global Availability report for network technologies, and part of the report is graphic:

• Chart availability for different network types for last "n" months' time.
• Charts availability for each region (for开发者_如何学运维 each network type for "n" months' time).

She (co-worker) had a global chart, but for each region, she did a separate sub-report containing just the chart for that region. The query isn't optimal, and using the sub-reports, the query is repeated each time.

If there a way to use a single data-set in one report for all five charts, forcing the four regional charts to display only that region's data?

Additional info: The charts are all Bar charts, design is y-axis: calculated availability x-axis: Group by network type (Switches, Trunks, "Network) sub group by month

Bad Example:

---

Let me see if I understand this. In your Report Header, you have 5 Subreports for the 4 regional graphs and the global graph. And you want to collapse this all into 1 Subreport if possible?

Yes, but you can't do it like in your image where United States & Europe are side-by-side. They would have to be 1 per row. Also, the datasource also has to be formatted correctly. To do this,

1. Make a new subreport. Group it by the Region.
2. In this subreport, make your regional graph in the Group Header section.
3. In this subreport, also make your global graph in the Report Header section.
4. Insert this subreport into your main report and you should be done.

---

Sometimes, the only way out of the fire is through it.

After lots of un-satisfactory refactoring, I spoke with the original (years ago) requestor and got some good information. I have yet to speak to the most recent requestor again (who didn't have any knowledge of the technical requirements the last several times).

Spoke w/ the guy who is tending a related db, and I get permission to add come functions, views, store procedures, etc. to THAT db... Within reason and after code/perf review -- something that isn't normally conducted, so I welcome it. I WILL have the ability to do the procedural stuff through... a procedure. Written as a stand-alone, I should be able to re-use it for any of the queries against future needs.

And... Yes, I am pretty much going to have to (read "get to") re-design, and hopefully get rid of most of the sub-reports. Yeay, me.

Thanks for coming along for the ride.