SQLServerCentral.com / Reporting Services / Reporting Services 2008 Development / ssrs 2008 r2 export to excel on report server problem / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 16:26:26 GMT20RE: ssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxCan you let me know what the DataOutput option is that you are referring to once you get to work on Monday? Thanks!Sun, 01 Dec 2013 14:32:24 GMTwendy elizabethRE: ssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxI'm not sure one would work and not the other. I use it to hide the entire tablix, not just columns. The interactive Option I hadn't seen before. I had to go look it up (I'll read [url=http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx]this [/url] on monday).try dropping the Globals!rendername.Name into a text box and see what it returns. If this doesn't work for you there's a property of the tablix textbox called something like DataOutput. I'm at home so I don't have easy access to BIDS at the moment.Sat, 30 Nov 2013 20:12:25 GMTSteven.HowesRE: ssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxYou are correct that I have think you have Bids 2008 and SSRS 2012.I have the following additional question which is:Would you tell me what the difference between the following 2 statements are:1. IIF(Globals!RenderFormat.IsInteractive, False, True) and2. =IIF(Globals!RenderFormat.Name = "RPL", true, false)Note: I can not get the columns to hide when I use the code "=IIF(Globals!RenderFormat.Name = "RPL", true, false)"Can you tell me why one works and the other format does not work?Fri, 29 Nov 2013 21:56:03 GMTwendy elizabethRE: ssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxFor the Parenthesis:=IIF((Globals!RenderFormat.Name = "EXCEL" OR Globals!RenderFormat.Name = "PDF"), False, True)Nested=IIF(Globals!RenderFormat.Name = "EXCEL" , False, IIF(Globals!RenderFormat.Name = "PDF", False, True) )I think you have too many versions in part 3. lol Do you mean Bids 2008 and SSRS 2012?Thu, 28 Nov 2013 14:30:31 GMTSteven.HowesRE: ssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxThank you for your answer! I have the following additional questions/items to mention:1. Can you show me the code of how you would use parenthesis or nest the iif statements?2. Do you think if I tried one of the following statements the code would work: either "=IIF(Globals!RenderFormat.Name = "RPL", true, false)" or"=IFF(Globals!RenderFormat.IsInteractive, False, True)", 3. I am using bids 2008 (visual studio 2008) and the report runs on SSRS 2008 2012. Would that make a difference? If so, what difference would it make?Thu, 28 Nov 2013 14:25:15 GMTwendy elizabethRE: ssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxI have the almost exact code in a report of mine and it works, though I don't have the OR in the IIF. Maybe encapsulate them in parenthesis or try a nested IIF?Have you looked in the report server logs to see if there's an error?Thu, 28 Nov 2013 06:56:50 GMTSteven.Howesssrs 2008 r2 export to excel on report server problemhttp://www.sqlservercentral.com/Forums/Topic1518133-1633-1.aspxIn 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?Wed, 27 Nov 2013 09:56:27 GMTwendy elizabeth