Share via

SSRS ReportName not displaying correctly

SCHBwh 1 Reputation point
2022-01-26T13:12:50.09+00:00

Hello,
I have nested reports, I.e. sub-reports in four levels..
TopLevel / subOne / subTwo / subThree
TopLevel has a page footer with place holder containing "=Globals!PageName"
subThree is Report / Body / Rectangle / ReportItems
The Rectangle has PageName=Globals!ReportName & " : " & Variables!version.Value

However when TopLevel is rendered ,either locally in VS 2019 cw SQL Reporting Services 15.0.19528.0 or deployed to SQL 2019 cw SSRS 15.0.7545.4810, I see the PageName displayed as "x11x18_subThree".

I can't see where the "x11x18_" is coming from.. I've looked in the ReportServer database catalog table, searched the .rdl files used by Visual Studio.
Can any one suggest the source of the "x11x18_" prefix? The report filename is subThree.rdl, InitialPageName is not set for subThree.

TIA.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2022-01-27T03:36:39.533+00:00

    Hi @SCHBwh

    I did a local test，and I have the prefix too，I think it's a way to show that this is an inline subreport, it can't be changed, but you can use expression to filter out the prefix. 

    =RIGHT(Globals!PageName,Len(Globals!PageName) - InStr（Globals!PageName，"_"))

    Best Regards,
    Isabella

    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments