Charting 12 summary values in report footer

[ClarkJeff]

I have 12 monthly totals in separate fields in the Report Footer. The totals are summed from separate monthly fields in Details, where the data in the monthly detail fields is determined by a formula in each field. There is no grouping, nor is there a way to group on the raw data. I can display each total value in the Report Footer, but cannot figure out how to display the 12 values in a simple bar chart. Bar 1 is month 1, bar 2 is month 2, etc. I don't see how to do this simple chart. I've also tried a subreport, per CR Knowledgebase, but the solution was for 8.5 and my 9 appears/acts differently. Can I pass the monthly totals to Excel, create the chart, and display it in the Report Footer on the fly? Any suggestions?

Thanks.
Jeff Clark

 

[lbass]

I just tried this using a manual crosstab for data (your data layout sounds like a manual crosstab), and it seemed to work:

Insert a chart, choose bar, choose advanced layout. Select each of the twelve summary fields from the explorer and enter it in the "Show values" box. For "On Change Of" add your date field, select it, and choose "Order". Select "specified order", and enter "All Dates" or whatever name you want, click on New and select the entire date range for your report--so that, in effect, there is no "change". Your 12 fields should now display as separate bars.

-LB

 

[lbass]

Just realized from reading your post to an earlier thread and exploring a little more, that the "On change of" area is actually a dropdown where you can select "for all records"--choose this, and you don't have to bother with the specified order I suggested above.

-LB

 

[ClarkJeff]

lbass,
Thanks for the replies! The problem is that I don't have a date field to select for the "On Change Of" field and the summary fields are generated in the report. I've tried an alternative of generating month numbers in the query and it seems to be working so far. I think I'll continue this route, as nothing I've tried the other ways has worked successfully. I was hoping there was something that I didn't see that would allow the simple charting. Thanks for all of your help!

 

[lbass]

You don't have to add any field to the "on change of" box, just select "use all records". I assumed your summaries were automatic. Are you sure they don't show up in the field box within the chart for selection as summary fields?

-LB