I have a main report with subreport which both pass values to a second subreport which does some calculations and passes the grandtotals for several columns back to the main report. This all works fine, but when I attempt to insert a chart, I do not see the grand total formulas in the list of 'available fields'.
I tried to 'wrap' these formulas in additional formulas, and these show up in the list, but show on the chart as equal to zero, despite showing right next to the chart as having a value.
Will the chart expert choke on anything that is not pretty much a straight number?
I tried a trick I have used before where I just calculated the percents myself and used these to create the chart, but, although these formulas show in the list, they don't appear to have any 'value' according to the chart output.
The pie doesn't show at all, just a list of the formulas used with the corresponding colors.
Here is an example of what my report looks like:
cust serv. collections other total
123.00 50.00 45.00 218.00 - subreportA
100.00 50.00 50.00 200.00 - subreportA
80.00 20.00 100.00 200.00 - subreportA
---------------------------------------
303.00 120.00 195.00 618.00 - main report
I would like the pie to show the percents that the first
3 columns make up of the total column.
I've tried putting this in a year group footer vs. the report footer, using 'on change of' year vs. for all records. I am getting nowhere.
HELP, please!
Thanks.
I tried to 'wrap' these formulas in additional formulas, and these show up in the list, but show on the chart as equal to zero, despite showing right next to the chart as having a value.
Will the chart expert choke on anything that is not pretty much a straight number?
I tried a trick I have used before where I just calculated the percents myself and used these to create the chart, but, although these formulas show in the list, they don't appear to have any 'value' according to the chart output.
The pie doesn't show at all, just a list of the formulas used with the corresponding colors.
Here is an example of what my report looks like:
cust serv. collections other total
123.00 50.00 45.00 218.00 - subreportA
100.00 50.00 50.00 200.00 - subreportA
80.00 20.00 100.00 200.00 - subreportA
---------------------------------------
303.00 120.00 195.00 618.00 - main report
I would like the pie to show the percents that the first
3 columns make up of the total column.
I've tried putting this in a year group footer vs. the report footer, using 'on change of' year vs. for all records. I am getting nowhere.
HELP, please!
Thanks.