Need Help with charts

[tttggg]

Is it possible to break the number of bars in chart and have 2or 3 charts.For example the chart 1 will have the 1st 20 rows and the chart 2 will have 2nd 20 rows and so on. If this is possible, can you please tell me how to do it. I really appreciate your help with this issue.

 

[lbass]

You can cluster your "on change of" field in a formula to return a certain number of values per group, and then insert a group on this, and place the chart in a group section. If you have a sequential field, it is simple. Otherwise, sort your records in order of the "on change of" field, and then insert a group on this formula:

whilereadingrecords;
numbervar cnt := cnt + 1;
numbervar i;
numbervar j;

for i := 1 to 2000 do( //replace 2000 with a number larger than the count of your "on change of" field
if cnt in 20*i-19 to 20*i then
j := i
);
j

Then place your chart in the group section.

-LB

 

[tttggg]

Sorry for the late reply,
I'm fairly new to CR. Can you explain little more how to do this. I don't have any groups in my report.Do i have to group the number of rows?.Where do i have to insert the formula?.
Can u please give me little bit more explanation here.

 

[lbass]

There really IS no more explanation. Create the formula above in the field explorer, and then go to insert->group and choose this formula. Place the chart in a group section.

-LB

 

[tttggg]

I got it. Thanks for the help. But i have an issue here.
Is it possible to keep all the graphs together. Because now i have the data then the chart and then data and so on. Instead of this i would like to have all the data (tables) together and the charts together. Your help is much appreciated here.

Thanks

 

[lbass]

I would suppress the details section and then add the data in a subreport in the report footer. Or you could put charts in a subreport, using the above approach in the subreport.

-LB