Groups | Blog | Home
all groups > sql server reporting services > january 2006 >

sql server reporting services : Toggle Column Visibility in Table


LureManGary
1/6/2006 2:33:02 PM
I have a table report with two levels of Groupings. Dept-Employees-Detail...

The table has 8 columns total, with drilldown enabled.

When you first open the table you see the first and last colmn of data
(department and hours worked) when you toggle the department field you see
the employee name and the hours worked. then you toggle the employee name and
see the details of hours worked by task, and cost center, etc. Before you
toggle the department field you can still see the column heading but not
data.

My question is, how do I hide the column heading so you only see the first
and last columns until you toggle the first group (dept)? I don't want to see
the columns with no data, unless I drill-down.

When I select the column in the Layout view and go into the properties I can
set the Hidden property to True but the ToggleItems drop-down is blank. I
don't understand why I can't toggle the visibility of a column based on a
Group. Like you can toggle the visibility of a row based on a group.

MACNR
1/9/2006 2:05:03 AM
there is no toggle item field because you have already made some of the
column hidden, while the actual column intself is visible.

Try making everything in the column visible again with no toggle items. Then
click on the table, and then the grey bar at the top of the column to select
the whole thing, then do the visibility on this, not just individual cells in
the column.

Hope this helps.

[quoted text, click to view]
LureManGary
1/9/2006 8:41:03 AM
I have double checked all the cells in the column and they are all set to
Hidden = False.

I made sure that all the rows and groups in my table are set to Hidden =
False.

I then selected the entire column and the Toggle Item Field is still blank.
When I select a row or Group the Toggle Item list is normal, (i can see the
group items and fields). Why can't i see this at the column level?




[quoted text, click to view]
AddThis Social Bookmark Button