Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbradish
Starting Member
24 Posts |
 Posted - 2010-02-22 : 15:41:33
|
| Does anyone know how to reference the toggle item in SSRS08? I'd like to change the font of my group header based on the whether the detail is hidden or displayed. I've found several people on the Internet asking this question, but I haven't come across an answer.Example+ToggleItem Group1 Total1 Total2 Group2 Total1 Total2 Group3 Total1 Total2If a user clicks on the report's ToggleItem, the report needs to look like this:+ToggleItem Group1 Total1 Total2 Detail Line 1 Detail Line 2 Detail Line 3 Group2 Total1 Total2 Detail Line 1 Detail Line 2 Group3 Total1 Total etc. etc.Whether my group headers are bold/red/default isn't contingent upon a Sum() or Count(), but upon whether the user has chosen to toggle the detail.Toggle Off = default font settingsToggle On = group headers in bold redI would expect a report property to do this. Such as =IIF(ReportItems!ToggleField.ToggleState = "true" ...) /OR/ =IIF(Table1_Details_Group.Hidden = "false" ...)Any ideas?"Challenge me. I will not give up. I will not succumb to any situation. I will not be afraid to be great." ~ D. M. Abrashoff |
|
|
|
|
|
Change Font Based on Toggled State