expand all node in SQL Reporting Service?

Hi

By default when we try use 开发者_Python百科grouping in reports, in output we had collapsed all node in view but this isn't good.

So after searching I found this solution: "use Toggle Item". but when I set value for this property my report crashed and in result I had no filed value in view.

which one is the solution? toggle Item or other way?

(if toggle item is solution post sample as answer)

---

In reportbuilder 3.0 you have to edit the group properties and change the visibility option to “Show” when the report is first run.

I don’t know exactly where it is on reportbuilder 2.0 but I would imagine this will put you on the right track