News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) FetchXML Reports and H...

Microsoft Dynamics CRM (Archived)

FetchXML Reports and Hiding Images

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Is it possible to show and hide images based on a value in another field in reports online? I keep getting an error "This report can’t upload because there are restrictions with SQL Server Reporting Services reports when Report Definition Language (RDL) Sandboxing is enabled."

I am using VS2012

The image is in the header and some text in the footer. I am using the following expression

show Image 1

=iIF(Fields!pricelevelid.Value LIKE "*something*", true, false)

show Image 2

=iIF(Fields!pricelevelid.Value LIKE "*something*", false, true)

If I remove these expressions report uploads fine.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: FetchXML Reports and Hiding Images

Then something is considered as denied in your formula. I would suggest to find that member and try to find a replacement for it. Good luck.
Community Member Microsoft Employee on at

Like (0)

Report

RE: FetchXML Reports and Hiding Images

If I remove the expression from the report used to show/hide the images the report imports just fine.
Suggested answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: FetchXML Reports and Hiding Images

Hello,

I don't see IIF in the list of denied members - technet.microsoft.com/.../dn531138.aspx

I believe you have other issue with your report that block import of it to Online Environment.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans