Click here to Skip to main content
15,664,435 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Ok! hi!
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?
Help Please.

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)...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900