Solved

SSRS Toggle Column Visibilty

Posted on 2014-03-24
2
378 Views
Last Modified: 2014-04-22
I am trying to hide columns when the drilldown is not selected on a report. I pulled the group ID from the report and when I try to use this expression:
=iif(Fields!table1_Details_Group.Value=1,false,true)

I get the message "Unknown Collection member" on the group. I know this group ID is a valid group ID. How do I get this column toggle to work?
0
Comment
Question by:rwheeler23
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39953858
0
 

Author Comment

by:rwheeler23
ID: 39954440
Yes, I think the problem starts with the fact that the group does not appear in my object list. Why it does not is a mystery. The drill down works just fine.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
debugging reporting service 2008 - 2014 16 78
SSRS Lookup to match Oracle date with SQL Server Date 4 41
exporting a ssrs report to word 2 46
Ssrs date parameters 12 71
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now