| |
ActiveReports for .NET 3.0 Support
Started by crazydw99 at 03-08-2010 2:40 PM. Topic has 3 replies.
  
|
|
Sort Posts:
|
|
|
|
 03-08-2010, 2:40 PM
|
crazydw99
Joined on 03-09-2010
Posts 2
|
Posting a subreport in the report footer
|
|
|
|
|
First of all, I am fairly new to AR 3.0, so perhaps I'm just overlooking the obvious here.
There is a need in our office to report on the results of an internal survey over a given timeframe. I've created the report that gives the scores back for each of the 10 questions from each customer. Now I'm trying figure out how to put the average rating (or grade) in the report footer based on these results.
It seems to me that this should be fairly straightforward. Can anyone point me in the right direction?
|
|
|
|
|
Report
|
|
|
|
|
03-09-2010, 12:10 AM
|
AnkitN
Joined on 03-03-2009
Posts 844
|
Re: Posting a subreport in the report footer
|
|
|
|
|
|
Hello,
I am assuming that your report structure would be like:
- PageHeader
- GroupHeader --> bound with customer unique field
-Detail
- GroupFooter
- PageFooter
And you want to find the average for each customer. If this is the said scenario then I suggest you to add a textbox in the GroupFooter of your report and set the following properties for this textbox.
Me.TextBox1. DataField: the field that you want to summarize
Me.TextBox1.SummaryFunc = DataDynamics.ActiveReports.SummaryFunc.Avg
Me.TextBox1.SummaryGroup = "GroupHeader1" ‘GroupName
Me.TextBox1.SummaryRunning = DataDynamics.ActiveReports.SummaryRunning.Group
Me.TextBox1.SummaryType = DataDynamics.ActiveReports.SummaryType.SubTotal
For more information you may check this link.
Regards,
Ankit Nigam
|
|
|
|
|
Report
|
|
|
|
|
03-09-2010, 6:42 AM
|
crazydw99
Joined on 03-09-2010
Posts 2
|
Re: Posting a subreport in the report footer
|
|
|
|
|
|
Yes, but that is only half the battle. The challenge is that once we have found the averages per customer, we'd like to find the overall average of the entire report.
|
|
|
|
|
Report
|
|
|
|
|
03-09-2010, 10:08 PM
|
AnkitN
Joined on 03-03-2009
Posts 844
|
|
|
|
Hello,
To find the overall avg. you need to use 2 global variables, one to calculate the total avg and other to calculate the total number of customers. Please find attached sample which implements the desired behavior.
I hope it helps.
Regards,
Ankit Nigam
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » ActiveReports f... » Re: Posting a subreport in the report footer
|
|
|
|
|