SSRS Built-in Field "RenderFormat.Name" is invalid

(0) Share

Report

Posted on by Community Member

Hi all,

i got the task to hide some columns on a report print out.

So i do some research and found the Built-in Field RenderFormat.

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-built-in-globals-and-users-references-report-builder

I go into VS, right click on the column -> Column Visibility -> choose "show or hide based on an expression" -> write this expression:

=IIF(Globals!RenderFormat.Name ="WORD" OR Globals!RenderFormat.Name="XML" OR  
  Globals!RenderFormat.Name="CSV" OR Globals!RenderFormat.Name="TIFF" OR   
  Globals!RenderFormat.Name="PDF", Globals!RenderFormat.Name="MHTML" OR 
  Globals!RenderFormat.Name="EXCEL",true,false)

and try to deploy.

VS shows this error message:

Have anybody an idea why i can't use this Built-in Field?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

This sounds like a pure SSRS question, you might get an answer faster on a forum dedicated for that area:

social.msdn.microsoft.com/.../home

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Vilmos for the advice.

Ask my question also there, here is the link: social.msdn.microsoft.com/.../ssrs-builtin-field-renderformatname-is-invalid

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi JamesnxD,

Should it be "OR" instead of "," ?

Globals!RenderFormat.Name="PDF", Globals!RenderFormat.Name="MHTML" OR

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ievgen,

you are right, this is a mistake. I replaced the "," with a "OR", but nothing changes. I still get the error message.

Was this reply helpful? Yes No