Report Name Extension Replacement
If your report contains the parameter Globals!ReportName and you decided to move this report from SharePoint to Native Mode it is very likely that you have to add &”.rdl” to the end since Globals!ReportName does not contain the extension in Native Mode.
For the report to work on both environments add the following code under Report Properties > Code
Public Function ReportExtension(ByVal ReportName As String) As String If Not ReportName.ToLower.Contains(".rdl") Then ReportName += ".rdl" End If Return ReportName End Function
Then just call it by using the code
=Code.ReportExtension(Globals!ReportName)
by william Mendoza