show/hide method in Export PDF and EXCEL

Question

Hi I try last 5 hrs but i didnt solve my proble

I have 1.Textbox 2.Image

When Export PDF or preview VS2005/Browser its show the Image
When Export EXCEL its show TextBox .

My show/hide

=IIF(Globals!RenderFormat.Name ="EXCEL",True,False)

PDF:
=IIF(Globals!RenderFormat.Name ="PDF",True,False)

please anybody help me.

Thanks
Shanvitha

s

Answer 1

Hi @Shanvitha ,

You may try the expression like shown:

show the Image when Export PDF or preview:

=IIF(Globals!RenderFormat.Name ="PDF" or Globals!RenderFormat.IsInteractive,false,true)

show the textbox when export excel:

=IIF(Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL",false, true)

Hope it will work.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

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.
Hot issues October:
https://learn.microsoft.com/en-us/answers/questions/142427/users-always-get-connection-timeout-problem-when-u.html