Consider there are four Vendor Accounts.Each vendor accounts has numerous transactions.The SSRS report Contains Vendor Account Field and a grid for all transactions.During report generation,normally we can create page number using “PAGE NUMBER” built in functions which begins with 1 and continues then on.But my criteria is to Reset the page number to 1 when Next Vendor Transactions are displayed.
Ex:
Page 1 |
---|
Vend account 1 |
Vend transaction1 |
Vend transaction2 |
Page 2 |
---|
Vend account 1 |
Vend transaction1 |
Vend transaction2 |
Note that Page number must change to 1 for next Vendor in Report
Page 1 |
---|
Vend account2 |
Vend transaction1 |
Vend transaction2 |
Page 2 |
---|
Vend account2 |
Vend transaction1 |
Vend transaction2 |