Design Report Viewer with page break in ASP.Net

Hi Muddassar

I am using asp.net vb and Report viewer. I have database table in MSSQL 2019. I need continue print out when select between date.

Design the Report:

I have Report 3 section, One is Page Header, Details,Footer PageHeader have Company name and address

I have drag and drop 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.

Grouping:

I have created a parent group in tablix in selecting "Add Group" > "Parent Group."

I choosed to group by "Code" and "Name."

Sorting: I did sorted by "Code."

Page Breaks:

I did Page Breaks option to Between In the Group Properties for the "Code" group

It is code

select code,name,invno,sum(Qty) as QTY from [dbo].[SA_Agent_Invoice]  
WHERE sodate >= @DATEFROM and SoDate <= @DATETO  
group by code,name,invno   order by Code