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.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Export to excel hide some columns in 2nd tab

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2014-11-07 : 03:22:41
Hi Experts,

I am creating SSRS report (export to excel needed) with requirement is like each months data is placed on new excel tab and in tab of month March I need few columns not all columns like in other tabs

Will that be possible to do?

T.I.A

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2014-11-13 : 01:31:58
Resolved it by creating two different tables and page break property of tables. :)

Now my next issue is when my second table is blank i have put hidden expression but as my header is common which is in header section i am getting blank sheet with header and sheet name is like "ABC1"

I have given first sheet name as "ABC"

How to resolve it or else atleast i can give the sheet 2 name as "Sheet2" but not "ABC1"

T.I.A
Go to Top of Page
   

- Advertisement -