Hi,
I am creating a report for a membership database that lists all members of the organization, grouped by US state. For each state, each member record is displayed in a row with several columns of data (e.g., first name, last name, address, etc.). One of the columns is called "member type" and has values such as "youth", "adult", and "honorary". What I would like to do in the group footer is display a summary of the count of each member type found in the given US state. The table should look like this:
Member Type Members
------------------- -------------
Adult 105
Youth 28
Honorary 5
......
I created the report and everything looks great except I cannot figure out how to create this summary data in the group footer. Each state's members are grouped and displayed correctly but each state should have its own table at the end of each group section. I have tried a crosstab, creating a subreport but to no avail. Any advice is much appreciated.
I am creating a report for a membership database that lists all members of the organization, grouped by US state. For each state, each member record is displayed in a row with several columns of data (e.g., first name, last name, address, etc.). One of the columns is called "member type" and has values such as "youth", "adult", and "honorary". What I would like to do in the group footer is display a summary of the count of each member type found in the given US state. The table should look like this:
Member Type Members
------------------- -------------
Adult 105
Youth 28
Honorary 5
......
I created the report and everything looks great except I cannot figure out how to create this summary data in the group footer. Each state's members are grouped and displayed correctly but each state should have its own table at the end of each group section. I have tried a crosstab, creating a subreport but to no avail. Any advice is much appreciated.
1 Answer, 1 is accepted
0
Hello Dave,
You need to use the ReportItem.DataObject property to get to the group underlying data. Your nested table should have a binding that connects its data source to its parent's data. Take a look at the "How to use the ReportItem.DataObject property in expressions" documentation article, which explains the procedure in details.
Hope it helps.
Regards,
Ivan Hristov
Telerik
You need to use the ReportItem.DataObject property to get to the group underlying data. Your nested table should have a binding that connects its data source to its parent's data. Take a look at the "How to use the ReportItem.DataObject property in expressions" documentation article, which explains the procedure in details.
Hope it helps.
Regards,
Ivan Hristov
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.