Grouping data is a feature you always needs when you are working with reports and relational data bases. In this post I’ll show you how to do it with NRapid.
In this case I’ll build a report to show products grouped by category, this report is going to show the whole list of products for the whole list of categories in the Northwind database, so there is no filtering options (no dialog).
If you take a look at the SQL statement, you will notice that there is no group by instruction, the grouping is done by using the NRapid fluent interface. (I don’t like SQL very much so I usually use the fluent interface, but if you‘re a SQL guy, you can solve the grouping inside the SQL instruction, it’s also going to works)
Now we are going to change the report options and set the Staked option on. This setting is going to change the layout and show us a most commonly seen format in this kind of reports.
This is just a sneak peak of NRapid grouping features. I’ll cover a lot more in upcoming post. Stay tuned.
You can get the source code of NRapid from here
And the sample app from here
The Northwind database is available from download at http://www.microsoft.com/en-us/download/details.aspx?id=23654