Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Column Invisibility Expand / Collapse
Author
Message
Posted Friday, October 11, 2013 9:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 8:47 AM
Points: 229, Visits: 701
I am trying to get the column associated with the table in the header so that it comes with a group on page at a time.
So, I add this column in the table and on the Header use Reportitems!columnname.value but when I hide the column in the table , the data associated in the header get invisible too.

I think thats the way SSRS works. But is there a work around?
I don't want it in table but need to display in the header.
Post #1504059
Posted Friday, October 11, 2013 1:25 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 531, Visits: 448
Change the color of the font for the field, in the report body to white and then keep the header a visible color like black.
Post #1504133
Posted Friday, October 11, 2013 1:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 8:47 AM
Points: 229, Visits: 701
Now it displays fine in the header but when I export it in pdf ,
the first page shows data on the header but the 2nd page is a copy of 1st but has no data.
is it because the columns are actually there just that the color is white ....
Post #1504139
Posted Monday, October 14, 2013 6:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 531, Visits: 448
If there is no data on the 2nd page, there will be nothing to pass to the header. Unless I am not understanding?
Post #1504422
Posted Monday, October 14, 2013 11:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 8:47 AM
Points: 229, Visits: 701
Changing : Consumecontainerwhitespace to true helped get all data on one page :)
Post #1504494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse