I am having some problems executing what I would think would just be a simple group by in a table. I have a collection of objects, say Person objects to make it easy. What I want to do is have a single table and group by the LastName with a count column with the number of people with that last name. So it would look like this
LastName Count
Smith 5
White 1
Doe 3
I have been messing around with the grouping within a table however every time I try to add a group even within my table it keeps adding the grouping record as the top row in my table above my header and then repeating the header with the data row each time.
Hi jerry hikel,
Thank you for your feedback; while this behavior is not supported via a designer based approach, I have forwarded the details of your experience with NetAdvantage Reporting directly to our product management team so that we may better satisfy the requirements of yourself and other developers using our products.
If you have any further questions that I may assist you with, please let me know.
Sincerely,Chris KDeveloper Support EngineerInfragistics, Inc.www.infragistics.com/support
I understand I could write code to do the grouping and then pass that grouped data to the report. The problem with that is then I would need to write code for every type of grouping I would want to do for every type of data I will be providing to a report. One of the benefits of a flexible reporting solution is to be able to provide that type of grouping functionality out of the box rather than requiring developers to pre-group data.
I would certainly prefer to be able to have the report designer work with grouping the data without forcing a table to repeat itself for each grouped item, but short of that the reporting infrastructure itself does support this, only not through the designer.
While manually modifying the Xaml as you are doing in your most recent approach may produce the behavior that you are looking for, a better approach would be to sum the data before it is provided to the report; in this manner, you can easily define the entire table in the detail section of the report. This would provide for better alignment for your data.
To provide grouped data, you could use the object data source and return the summarized groups.
Using this method will allow for better support and maintainability.
If you have any further questions that I may assist you with in the meantime, please let me know.
Actually I forgot to add the other column I am grouping by -- re-attached.
So I was able to get the report to have the proper table grouping and with a header that was not repeated. Unfortunately I had to manually modify the report file to get it to look like I wanted. I am attaching the manually modified report file so that you can take a look. I'm not sure if it would be possible to create a report in this format using the designer. I renamed the report file to .igr.txt because the upload facility does not allow .igr files.
Please advise.