Avatar of pratz09
pratz09
Flag for United States of America asked on

Hiding and toggling of items based on condition in SSRS

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 !
SSRSMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
pratz09

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
ValentinoV

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pratz09

ASKER
Yes you are right. I had to change Initial toggle property of textbox to get the desired effect. Thanks a lot.
Your help has saved me hundreds of hours of internet surfing.
fblack61