So, this could be a little bit large...
I have a store procedure that returns this table:
I colored for the explanation:
columns in yellow are data for the headers, and columns in green are the detail rows for every header.
the threatment for this table is the next:
I wanna group the rows by IdClient and IdCar, (the table is ordered with this secuence) in this case the result are four groups (marked in blue and gray because they are diferents combinations)
I need that the groups resulted of this grouping process splits on distinct tables (pages), and every table with diferent header (according data from yellow columns) and obviously with its own detail list (rows from the green columns).
so if you can undestand me the result from de image above would be this four pages (tables):
What is the best way to do it? Consider than in this case the result are 4 groups, but it could be more... or less
I was trying with reportviewer control and a dataset... and I can get and show the entire table... but how group it? and split it in 4 tables (pages) diferents???
is this the way? is there another ways?
Thanks a lot!!!
What I have tried:
the data source is a dataset with a tableadapter, the table result is returned from a store procedure (that recieves some parameters)...