|
-
May 3rd, 2021, 05:30 PM
#1
Thread Starter
New Member
Best way to multi page report on VB?
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!!!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|