Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-27 : 11:52:55
|
| In an SSRS 2008 R2 report, I have the following expression on the 'Hidden' property on the Tablixes where Ido not want the headings exported to EXCEL or PDF.=IIF(Globals!RenderFormat.Name = "EXCEL" OR Globals!RenderFormat.Name = "PDF", True, False)The code listed above works fine when I am using my visual studio bids ide.However when I deploy the code listed above to the test report server, the following occurs:1. The heading columns for PDF do not show up, however **2. The headings columns show up when I export the SSRS report to EXCEL on the report server.I do not understand why the code would work on the visual studio ide and it does not work on the report server.I also want to mention that when I change the code to the following:=IIF(Globals!RenderFormat.Name = "EXCEL" OR Globals!RenderFormat.Name = "PDF", False, True),that:1. the Excel report headings show up on visual studio and2. the Excel report headings do not show up on the report server.Thus can you tell me what could be causing this problem and what I can do to solve the problem?What code should I use? |
|
|
|
|
|
ssrs 2008 r2 export to excel issue on report serv