Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Report - Chart design


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?


That mean my bar should be like :

Standard Hisogram


aaa bbb ccc ddd

Former Member
Former Member replied


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

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

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.



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question