How can I Reset the page Number for each group in rdlc reports

Please follow the below steps to get the page n of m for each page

Step 1:  Make sure there's a textbox in the report which contains the group expression

Step 2:  Add shared variables to track the current group and page offset

 Shared offset as Integer
 Shared currentgroup as Object

Step 3:  Add a custom function to set the shared variables and retrieve the group page number

 Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object
  If Not (group = currentgroup)
   offset = pagenumber - 1
   currentgroup = group
  End If
  Return pagenumber - offset
 End Function

Step 4: Use the function in the page header or footer

 =Code.GetGroupPageNumber(ReportItems!Category.Value,Globals!PageNumber)

Note:  Because this uses static variables, if two people run the report at the exact same moment, there's a slim chance one will smash the other's variable state  (In SQL 2000, this could occasionally happen due to two users paginating through the same report at the same time, not just due to exactly simultaneous executions)  If you need to be 100% certain to avoid this, you can make each of the shared variables a hash table based on user ID (Globals!UserID).

NAV2009 Reporting Error

Sometimes the following error may occur while designing RDLC Report

     “The provided metadata is not valid”

This error can happen when the following conditions are true:

You are using Windows Vista and User Access Control (UAC) is turned on.

• The executable file that runs the Visual Studio development environment (devenv.exe) is set to run as an administrator.
• The executable file that runs the Classic client with Microsoft SQL Server (finsql.exe) is not set to run as an administrator.
• To resolve this issue, either turn off UAC or set both finsql.exe and devenv.exe to run as an administrator.

To turn off UAC

• In Control Panel, select User Accounts.
• In User Accounts, click Turn User Account Control On or Off.
• Clear the Use User Account Control (UAC) to help protect your computer check box.
• To set a program to run as an administrator
• Right-click the .exe file, and then select Properties.

In the Properties window, on the Compatibility tab, in the Privilege Level section, selectRun this program as an administrator.

How to Repeat Table Header on Each Page in NAV 2013 & NAV2013R2 Reports

After NAV2013 that the table header doesn't repeat when there is a next page.
Even the table properties Boolean Repeat Header Rows on New Page doesn't help.

So let's see how we can repeat header in New Page.

I will be doing it for NAV2013R2, and using Report Builder. The Steps Remain Same for NAV2013 also.

The following setting are required to repeat the header in New Page

1. Open the Layout of Report in

2. In the Column Group Pane Select Advanced Mode
3. Once in advanced mode you will see static Rows for Each Header Line

4. For Each Header Row that you want to repeat on New Page, select the corresponding Static Row and set these properties.

- Set KeepWithGroup to AFTER
- set RepeatOnNewPage to TRUE.


 When you click on a static Row, the corresponding row is selected in the table.

If you want to repeat all four lines in New Page, Repeat the steps for For all Header Rows.

Save the Report and Run in Role Tailored Client.