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.
Any feedback on this?
thanks.
Hi Jerry,
I am currently investigating this behavior for you and I will be following up with you via this forum thread with my findings.
If you have any further questions in the meantime, please let me know.
Sincerely,Chris KDeveloper Support EngineerInfragistics, Inc.www.infragistics.com/support
I was able to get the data to appear in the way that I want by using the report header as the locating for a set of labels that i am treating as a table header, and then using a grouping in a report section with another set of labels containing the data grouped in the way I want to represent each row in a table.
I have run into a few problems with this: I want the data to actually look like a table and trying to get everything to match up exactly has been an exercise in futility. It would be much easier if this were possible to do with a table rather than having to create sets of labels that act as the header and table rows. Also when designing the report in this way, in order to get the print-out to look right, the PDF looks terrible -- the border of the bottom row of the report is simply gone. Also the report viewer looks different than the PDF -- I had to change the size of my items in the report designer to get the PDF and printed report width to fit within the page while the report viewer now looks like it is only taking up about 1/2 the page width.
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.
Actually I forgot to add the other column I am grouping by -- re-attached.
Hi jerry hikel,
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.
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.
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.