Home > SSRS Expert > SSRS #70 – Just a little effort to set the toggle image correctly

SSRS #70 – Just a little effort to set the toggle image correctly

Expand or collapse the inner most row group is a common practice

If you have ever created Row Groups in reporting Services, you must also have tried to give users a chance to expand or collapse the inner most row group, such as the Details group.

I believe this is the correct way to use the toggle images

When the toggle item (the Textbox for Interval in the example)  has the (-) toggle image, the Details row group is showing all the rows.

image

When the toggle item (the Textbox for Interval in the example)  has the (+) toggle image, the Details row group is now hidden.

image

I believe the above two screen shots are using the two toggle images correctly.

But I have seen too many reports that use the two toggle images differently.

Here is an example.

Using the (+) image, but the details are showing.

image

Using the (-) image, but there are no detail rows.

image

Use two properties: InitialToggleState  and Hidden

If you agree with me that the first two screen shots are using the toggle images correctly, then here are two properties you can use to set it up in Reporting Services 2008.

To show the inner row group initially
  • Toggle item property: InitialToggleState = True
  • Inner row group property: Hidden = False
To hide the inner row group initially
  • Toggle item property: InitialToggleState = False
  • Inner row group property: Hidden = True

Here are the steps to show the inner row group initially.

1. Click on the toggle item (i.e. a textbox in the outer row group) so the textbox is in focus.

image

Press function key F4 to get to the Properties. Then set the property InitialToggleState to True.

image

(note sure if the message here from Microsoft engineers is correct)

2. Click on the Details row group(i.e. the inner row group you want to hide or display by users) so the row group is in focus.

image

Press function key F4 to get to the Properties. Then set the property Hidden = False.

image

Categories: SSRS Expert
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: