Chart SQL

This public forum is for user-to-user discussions of ASP Report Maker. Note that this is not support forum.

Chart SQL

Postby ready4data » Wed Jun 22, 2016 10:42 pm

My chart is calculating an average for a field(OverallPct). OverallPct is calculated by StudentsCertified/Students.
The problem is that the chart is averaging averages. This gives an incorrect value in the table summary and the chart.
How can I modify the field in the chart SQL to use the calculation rptPrepToCert.StudentsCertified.SumViewValue/rptPrepToCert.Students.SumViewValue

Thanks
Scott
ready4data
 
Posts: 276
Joined: Mon Nov 19, 2012 8:24 pm

Re: Chart SQL

Postby motfs » Thu Jun 23, 2016 6:17 pm

You may manipulate the Chart XML to correct the data. See Server Event and Client Scripts -> Chart_Rendered in help file for more details.
motfs
 
Posts: 710
Joined: Tue Sep 08, 2015 4:55 pm


Return to General Discussion (ASP Report Maker)