SSRS Report is exporting in 4 different tabs rather in one tab, I want it to be exported to one excel tab
-
Hi All, I have an SSRS report when we export it to excel, it is exporting in 4 different tabs rather in one tab, I want it to be exported to one excel tab. I have set the Disabled property in Page break to =IIF(Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL", true, false) but still no help. I even tried the following also =IIF(Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL", false, true) =IIF(Globals!RenderFormat.Name = "CSV" OR Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL", true, false) still no luck Can anybody please help me in this regard? I need some help any link, suggestion or code snippet any help would be really helpful. Thanks in advance.
Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA