Groups and Totals

Jul 28, 2009 at 12:18 PM

Hello hanswolff,

Great work! do you intend to add groupheaders and summary functions on your report engine!??!

Many thanks, you really helped me a lot!

Antonis

Jul 28, 2009 at 12:38 PM

I found how i can work with summary functions (through the InlineAggregateValue object).

Is there any way to create Groups?

 

Many thanks.

 

Coordinator
Aug 1, 2009 at 10:52 PM

Thank you for your suggestion. I intend to add some group functionality for next release.

Sep 15, 2009 at 11:09 PM

+1 to grouping

Oct 1, 2009 at 11:09 AM

+1 to grouping

Than you for your very good work :)

May 6, 2010 at 9:25 AM

+1 to grouping

Jul 28, 2010 at 12:55 PM

+1 to grouping with subtotals

Jul 30, 2010 at 6:10 PM
Edited Jul 30, 2010 at 6:13 PM

I think I got dumb solution.

Steps:

1) Create report template with no data (only header and empty data section)

2) In you app, read template with XAMLreader to, 4 example, StringBuilder

3) Get your data and define how many grouped items it will have

4) Iterate your data with a number of grouped items, in each iteration create dynamic table for single grouped item, with null header (add header only in first iteration), and append it to data section of your template in StringBuilder. Do not forget to set top and bottom margins of every table to 0, to have all tables together as single table in your report.

5) Render final template from StringBuilder to reportDocument.XamlData

6) Fill all dynamic tables with your data

7) Append footer

8) Profit

*you may need to add some additional properties to ReportData class, to display sum, average, count, etc. calculation values manually.

I'm almost sure it will work, now I'm working on how to correctly append tables to StringBuilder. If everything would work, I'll upload sample report here.

This is quite an ugly solution, but maybe it will be helpful for somebody...