show groups collapsed in reporting services 2005 2

[stanja]

Hello ,

I've got a report on sql server 2005 reporting services 2005 with several groups.How can i collapse/expand the groups ?
When i start the report now i receive al the groups expanded.
tx

Stanja

 

[Catadmin]

The table visibility is in the table properties when you choose the whole table and right-click it. The group visibility is in the properties window (usually at the right of your screen) when you highlight a row (group header row, detail row, group footer row). Expand Visibility (it's under the Appearance group) and you see Hidden and Toggle item.

I have a param in my report that, combined with an expression in the Hidden property, opens up the report either collapsed or expanded, showing only the header info if the choice is NO.

The expression I use is:

=iif(Parameters!OpenCloseDetails.Value = "C", True, False)

And OpenCloseDetails is set up with Available values of Non-queried: Label1 Yes Value O, Label2 No Value C with a default of C.

Does that help you out?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[xlbo]

yup - that's about the only way I know of doing it in RS 2000. Can be pretty neat if you have multiple expansion levels as you can set up several values in there to control which level of detail is shown

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[stanja]

tx , but what i need is that by default the groups are shown collapsed but that i can expand them by clicking on a + sign.

 

[xlbo]

in that case, simply set your groups to be collapsed by default
You will then need to set a textbox as the toggle control - this can all be set in the visibility options of a table / textbox etc

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Catadmin]

Geoff is correct. All you need is to set Visibility, Hidden property to TRUE and then set your ToggleItem.

If you set Hidden = TRUE and forgot to set the ToggleItem, you will NOT be able to expand the report because it won't put a toggle in there.

The ToggleItem is usually the Name property of a textbox/label on a higher row/level (can be same group, but must be a different line).



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Senjaya]

Hi Catadmin,

I have setup the Hidden=True and ToggleItem into Nameproperty of a textbox on a higher level.

Now my bos wants something like this : whenever you click on the (+) or (-) sign to display the level below it - he wants to set the original level when it got expanded the whole row become bold or different color and when it collapsed again back to original color.

Thanks in advance.
Happy ThanksGiving

 

[xlbo]

Best bet will be to set the background colour of the cells to be an expression which tests the visibility of the group

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Catadmin]

Ditto to what Geoff said. Use an IIF() in the expression box (If Then Else) to test if Hidden = True. It should search on that expression every time the report is refreshed.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"