Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pie Chart not working;

Status
Not open for further replies.

pelajhia

Programmer
May 19, 1999
592
US
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.
 
Look at Crystal's Help File and check the "Contents" tab for "Report Processing Model" -> "Overview" -> "Multi-pass reporting Flow Chart".

You will see that charts are produced BEFORE subreports and this is the cause of your problems.

Steve Phillips, Crystal Consultant
 
Rats. Thanks for the info, I will check out the help file, too.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top