Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
forantes
New Member

&ReportName is not showing up - Report Builder

Hi all,

 

I'm quite new to using report builder.

I'm working on a new report, and I'm trying to use the report name as title, I'm using the [&ReportName] from Globlas!ReportName, but when I run the preview mode nothing is showing up.

 

forantes_0-1654892368855.png  forantes_1-1654892401269.png

 

I saved already the file with the name "Report" for test, but nothing it's working. I also tried the other Global variables and they worked (like the total pages i'm using as subtitle in this test). I followed every step as they do in the Power BI Paginated Reports in a Day course from Microsoft but clearly I'm missing something.

 

Any idea?

1 ACCEPTED SOLUTION
sevenhills
Super User
Super User

It is NOT your steps or your fault. It is well known for many years in SSRS world. It will not work until you save on a server.

 

=Globals.ReportName

ReportName            String        The name of the report as it is stored in the report server database.

 

reference:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-built-in-...

View solution in original post

7 REPLIES 7
forantes
New Member

preview from server:

forantes_0-1654897948691.png

 

Glad it worked ... 

Please see, since you are trying as newbie, if you dont find answers as Paginated reports, try search in google the issue for SSRS, you will find answers.

 

Paginated Reports on the Power BI Service is same as SSRS. SSRS is there for many years.

Many thanks!

This is valuable information 🤓

Boricuanet
Frequent Visitor

 

Hi forantes

See if these steps work for you (sorry I have it in Spanish)

Boricuanet_0-1654897317899.png

Boricuanet_1-1654897428332.png

 

Boricuanet_2-1654897503584.png

 

Best regards

 

 

 

FYI, The user knows how to use it. The user is saying that it wont show on the report builder, which (the issue) is by design. 

Hope my reply is not rude to you 🙂 

sevenhills
Super User
Super User

It is NOT your steps or your fault. It is well known for many years in SSRS world. It will not work until you save on a server.

 

=Globals.ReportName

ReportName            String        The name of the report as it is stored in the report server database.

 

reference:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-built-in-...

Thanks, sevenhills!

 

I tried to publish it, but I had other issues with my Redshift connection and gateway, and I couldn't see the report on the server. I created another report without data and tried it, and it worked. I can see the report name once it was published.

Thanks again

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.