Crystal Report - Chart design

[Former Member]

HI,

I am new with Crystal report chart.

I had generate a crystal report with only display for data,

but i now i need to display my data in chart report.

can anyone told me how to do that?

below is my sample data.

aaa bbb ccc ddd

____________________________

data1 1 2 3 4

data2 4 4 4 5

data3 2 3 4 5

data4 1 1 1 1

____________________________

average 2 2.5 3 3.75

How do i generate average data in chart design?

Thanks

That mean my bar should be like :

Standard Hisogram

|__|___|_____|______|___________________

aaa bbb ccc ddd

[Former Member · Accepted solution]

hello,

you can create an average formula and then add that formula into the chart. to insert a chart click on Insert--->Chart.

To create an average you can use a logic like this

Whileprintingrecords;
Numbervar FLFWAvg;
Numbervar myaverage=0;
Numbervar CLFWAvg=0;
myaverage := {#TotalLensM};  
CLFWAvg:= myaverage /{@WorkingdaysLFW};
FLFWAvg:=FLFWAvg + CLFWAvg;
CLFWAvg

The above is a code which I am using for my report to get average lenses however you can use the similar approach for your average.

Please note: workingdays formula is used to calculate working days (i.e. exclude bank holidays and weekends).

Total Lens M is a running total of lenses.

Regards

jehanzeb