Charting Report Grandtotals from Manual Crosstab

[Jcfx]

I have to duplicate and excel spreadsheet.

I had to create a manual cross tab. The columns (categories) are created by if then else formula similar to the following:

If left(v.catcod,3) = "002" then v.price else 0

There are five separate columns with five separate formulas.

The report is grouped by item, details are suppressed, and the column group totals and the column report totals are displayed.

I need to chart the column report totals in the report footer.

Item  cat1 cat2 cat2 cat4 cat5
A     2.00  0    0   1.75 2.25 <----Group footer totals
B     3.25  1.00 0   0    0
Total 5.25  1.00 0   1.75 2.25  <----Report footer totals

The charts x axis is to be the categories, the y axis is to be the category totals.


Julie
CRXI CE10 / RS2005 Sql DB

 

[Jcfx]

Please disregard, I must have just been having a duh moment.

I solved my problem by going into Chart expert, advanced, and changing the drop down from "on change of" to "For all Records". Bingo.

Thanks

Julie
CRXI CE10 / RS2005 Sql DB