Click here to Skip to main content
15,844,477 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am using ASP.NET VB and Report viewer. I have a database table in MSSQL 2019. I need continue print out when select between date.
In data table, columns are Code, Name, InvNo, Qty.
There are the more than 100 code means customer.
If I select date, report viewer should show Code, Name above Details of INV No and Qty.
Every page, code should one page, another code should show page no 2.
Like this, 100 pages in single click. Code and name should be on top page. Other details should be in details section like tabular column. How to set up Report viewer?

The Page Header with Company Name and Address should be displayed at the top of each page.
The Code and Name (Customer) dynamically in each and every page.
In the Details section, the tablix displays Invoice details for the selected date range.
A page break occurs between different codes (customers), ensuring that each customer's data starts on a new page.

Please advice me. Thank you in advance!

What I have tried:

Design the Report:
I have Report 3 section, one is Page Header, Details, Footer
PageHeader has Company name and address
I have dragged and dropped a Table control (Tablix) onto my report design surface.
I have added Code and Name above Table control (Tablix).
I have added the columns: InvNo, Qty to the table.

I have created a parent group in tablix in selecting "Add Group" > "Parent Group."
I have chosen to group by "Code" and "Name."

I did sorted by "Code."

Page Breaks:
I did Page Breaks option to Between In the Group Properties for the "Code" group.
Updated 24-Oct-23 3:55am

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

Just posting your homework assignment and a vague "I need multiple pages" isn't going to help when we have no idea how you have implemented whatever you have done so far and no access to your system.

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
Share this answer

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