Seting a +/- Toggle Option to default to -

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.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Seting a +/- Toggle Option to default to -

Author

Topic

JeniQ
Starting Member

29 Posts

Posted - 2009-06-03 : 12:05:35

I have a textbox labeled 'Abbreviated Form' on my report. It successfully hides or shows a set of columns when activated.

However, I want these columns to display by default, so I've set the Hidden property to False on the columns.
Additionally, I would like the Expand/Collapse icon to default to a - rather than a + since all of the fields will be displaying initially.
How do I control the way that the +/- displays?

Thanks,
Jennifer

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-03 : 13:59:42

you've a property called initial visibility for toggle image.
just set it to expanded in your table

see below for details

http://www.mssqltips.com/tip.asp?tip=1329

JeniQ
Starting Member

29 Posts

Posted - 2009-06-03 : 14:45:37

Hrrm. I totally understand what the article is trying to do, and it is the end result I want to achieve. Unlike the example in the article you referenced, I am hiding a few columns, not a Group. But I don't think that should pose a problem. However, I cannot find the option I need. It looks like the screen shots in the article are from 2005, not 2008.

I'm in the Design Tab, and I select a Textbox, right-click and choose Properties, then select the Visibility tab along the left-hand side.
There is no Expand(+)/Collapse(-) choice.

In the Help file for 2005, it says that I should see the following options on the Visibility Tab of the Textbox Properties dialog box:
http://msdn.microsoft.com/en-us/library/ms180178(SQL.90).aspx
I cannot find a corresponding page in the 2008 help files.

Suggestions?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-03 : 15:00:49

Sorry i havent started using sql 2008 reports yet

VipulM
Starting Member

9 Posts

Posted - 2009-06-23 : 03:57:22

In 2008,

You have to set TextBox Property > Visibility > InitialToggleState = True to see "-" sign instead of "+".

Thanks,
Vipul Mochi

JeniQ
Starting Member

29 Posts

Posted - 2009-06-23 : 08:46:05

Thanks!!