Solved

Hiding and toggling of items based on condition in SSRS

Posted on 2012-03-12
2
2,205 Views
Last Modified: 2012-03-14
I am building a report with parameters and drill downs. Based on parameters, report may return tons of data or few rows of data. Therefore based on parameters I want to display report with / without drill downs.

First I thought of putting an expression in Hide property, which works. But toggle item property does not support expressions... so the rows are made visible but they still have toggles which forces user to click through to see just 1 row.

I am out of ideas, and would appreciate any help. Thanks !
0
Comment
Question by:pratz09
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 37713450
I'm not exactly sure what you mean with: "so the rows are made visible but they still have toggles which forces user to click through to see just 1 row"

As you've noticed, you can't change the ToggleItem value dynamically,  but I don't think that's necessary.  If you use an expression on the Hidden property and make rows "not hidden" whenever you require them to be visible, that should work.

However, what can be confusing is the behavior of the +/- toggle icon.  You will need to make it behave as expected too, by adding an expression on the InitialToggleState property.
Perhaps that's what you were having trouble with?
0
 

Author Closing Comment

by:pratz09
ID: 37723196
Yes you are right. I had to change Initial toggle property of textbox to get the desired effect. Thanks a lot.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS List box paramaters showing duplicate choices 2 46
convert null in sql server 12 67
Replication failure 1 32
What is GIS method of Geometry data type? 6 36
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

752 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