# Ax2012:Changing the Page Number based on a Field in SSRS Report

**URL:** <https://www.dynamicsuser.net/t/ax2012-changing-the-page-number-based-on-a-field-in-ssrs-report/43050>\
**Category:** Developer Forum\
**Created:** [January 21, 2013, 6:21am UTC](https://www.dynamicsuser.net/t/ax2012-changing-the-page-number-based-on-a-field-in-ssrs-report/43050 "2013-01-21T06:21:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![VenkateshN1988](https://avatars.discourse-cdn.com/v4/letter/v/8797f3/32.png) [@VenkateshN1988](https://www.dynamicsuser.net/u/VenkateshN1988)\
**Post date:** [January 21, 2013, 6:21am UTC](https://www.dynamicsuser.net/t/ax2012-changing-the-page-number-based-on-a-field-in-ssrs-report/43050/1 "2013-01-21T06:21:15Z")

</div>

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 account **2**  
 |
|   
Vend transaction1  
 |
|   
Vend transaction2  
 |

|   
**Page 2**  
 |
| --- |
|   
Vend account **2**  
 |
|   
Vend transaction1  
 |
|   
Vend transaction2  
 |