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 |
|
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 tabsWill 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 |
 |
|
|
|
|
|
Export to excel hide some columns in 2nd tab