How to add Drill down option in the Dataset ( + )

Dear Friends,

I have created a Dataset and displayed in the report. In the report, its showing as expanded values by default. There is no option for me to Collapse and Expand.

If I create a Table with Report Wizard, I am getting the Collapse & Expand ( + ) option in the report.

Is there anyway, I can add the Collapse / Expand in the Dataset kind of reports.

Thanks.

Warm Regards
Rakin
Singapore.

If you investigate the report that is generated through the report wizard, you will notice that the toggle-effect is achieved by setting the Visibility property e.g. of table rows to be toggled by a certain other textbox.

Please also check RS BOL for more information how to add toggles in report designer: http://msdn2.microsoft.com/en-us/library/ms156456.aspx

-- Robert

|||

Thanks Robert.

Now I am able to do that. It works fine.

Regards
Rakin.