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