Print time formula charting using shared variables...

[jcrawford08]

hello all,

I have an interesting conundrum; I am working on a report with no groups to it, just several subreports. Presently the report is run weekly and sent to the manager of one of our departments.

The report itself showcases all areas of the department with total tasks, longest outstanding task, average days outstanding, MTD tasks completed, and YTD tasks completed. Due to the variety of tables the data pulls from, I have it set up as subreports that simply display the data.

All total, there are 20 different shared variables that have been obtained from 10 different subreports. I have the shared variables set as the running totals from the subreports (hence, all are print time). Since the running totals and all the subreports are time based and are not actually linked to ANYTHING on the main report, I am struggling with how to set up the {@onchngof} formula.

The setting up of the two formulas ({@onchngof} and {@showval}) will be different for my situation, as all of the subreports run off of date information relative to when the report is ran. I've got all of the subreports that the shared variables originate in early in the report; but where to from here?

Would I set up maybe a date grouping or some other non-essential consistent grouping to make it work? The way this report is, it really doesn't need grouping, because the main report is just a display agent for the subreports...

As always, any help is greatly appreciated!

Not in word only, but in deed also... 1Jn3:18

 

[jcrawford08]

My flaw in design on this was that I was trying to pull the shared variables back into the report to then just conglomorate all of the data into a couple of massive graphs.

The fix proved to be actually displaying the graphs in the subreports themselves as opposed to trying to display the graphs in the main report.

The end user wanted to have a summary sheet with all of the graphs following it; once the graphs were built, then to show the summary I just saved the subreports with the graphs and pulled in copies of them without the graphs.

Those without the graphs were placed in the headers of the report (in this case the report is really only a display agent of all the data contained in the various subreports), and the subreports containing the graphs into separate detail sections, adjusting each as needed for consistent page breaking and presentation.

There was, however, one stat that pulled from several tables that I had to use shared variables on and was not able to display in a graph.

Someone can feel free to correct me, but I don't think there is a way to pull a graph using multiple shared variables ONLY.... (i.e. (sharedvarA+sharedvarB) as bar1 on the graph and (sharedvarC+sharedvarD) as bar2 on the graph).

If there is a way, I'd love to know, but it doesn't appear that the ability to concretely designate data to be displayed in a graph that is not associated in the same report and has to be pulled in through alternate means (i.e. subreporting) exists within the current Crystal Reports (or at least CR XI)... again, correct me if I am wrong

Not in word only, but in deed also... 1Jn3:18