I need to display a DataTable in a report.
So as the DataTable is not grouped or sorted in any case I need a way to display the DataTable using different Group By options (e.g. by Date, by Customer ...).
As I'm doing my first report in this way with VS 2008 and reporting services maybe you can give me a hint how to make the report.
I think I've to use different reports for any case I need like:
1. Report by date
2. Report by customer
And how to group the data - can Crystal Report do so or have I need to use something like LinQ?
As the DataTable will bild in memory I can' use something like a group by query ...