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 |