I need to chart the data from a rep

[ramc2000]

I need to chart the data from a report where I've created a manual crosstab. The 5 columns in my report are displaying the contents of 10 different counter variables I have defined.

My report looks like this:

range1 range 2 range 3 range4 range5
store1 @formula1 @formula2 @formula3 @formula4 @formula5
store2 " " " " "
store3 " " " " "
Totals @formula6 @formula7 @formula8 @formula9 @formula10

@formula1 contains the following:
whileprintingrecords;
numberVar Range1;

and @formula6 contains:
whileprintingrecords;
numbervar Rango6Total;

I need to chart the percentage the values in @formula6 through @formula10 represent compared to the grand total.
How can I get CR 8 to chart this data? the problem is that since these columns are all variables and not table fields, I can't use the "On Change of" drop down list in the chart expert to chart a value each time the range changes.
Any help will be greatly appreciated.

 

[IanWaterman]

Just go to Insert Chart, select the data tab.

On the left hand side you will see layout, select Advanced.

This will then allow you to place your manual Cross tab formulas as you wish.

Ian Waterman
UK Crystal Consultant

 

[ramc2000]

IanWaterman, altough I'm able to insert my formulas in the "Show values" section of the chart expert, the issue is rather, with the "on change of" drop down list.

Perhaps a little explanation of what my report is actually doing would help. My report is showing the number of orders our warehouse is shipping out to our different stores classified by the number of days passed between receiving the order and shipping it (therefore date ranges range1...range5).
The values in @formula1 to @formula5 are being calculated at the details level with the following formula:

//calculating time to prepare order
//@Difference
Int ({DateOrderShipped}-({DateOrderReceived}))

and then I use variables to count the number of orders for each range (at the details level too):

//@CountNumberOfDays
whileprintingrecords;

numberVar Range1;
numberVar Range2;
numberVar Range3;
numberVar Range4;
numberVar Range5;

numberVar Range1Total;
numberVar Range2Total;
numberVar Range3Total;
numberVar Range4Total;
numberVar Range5Total;

select {@Difference}
case Is <-2:
(Range1:=1+Range1;
Range1Total:=1+Range1Total
case -2, -1:
(Range2:=1+Range2;
Range2Total:=1+Range2Total
case 0:
(Range3:=1+Range3;
Range3Total:=1+Range3Total
case 1,2:
(Range4:=1+Range4;
Range4Total:=1+Range4Total
case is >2:
(Range5:=1+Range5;
Range5Total:=1+Range5Total;

I reset the range1 to range5 variables at the group header level (each store is a group) while the Range1Total to Range5Total are never resetted.
Now, the problem is that I want to chart the values in Range1Total to Range5Total for each date range, so I think I should use the &quot;on change of&quot; drop down list, but I don't have any table or formula field to insert in that area and I was wondering what would be the way to accomplish this. Hope this helps to clarify my problem, Thanks.