how to drilldown for some part of data in ssrs reports 2008

Hi I ha开发者_如何学Gove to put drill down option for some part of Data. My requirement is..I have 50 suppliers and i have to show top 10 suppliers as normal and for remaining 40 suppliers i have to put drill down option in ssrs report 2008

Please help.

In the Row Visibility properties of the row on which you've activated the +/- toggle (which is the window where you've activated the "Display can be toggled by ..." option), you can use an expression to show or hide the row. That means that you'll need to add something to your dataset so that you can decide whether or not a row should be shown by default.

You'll also need to add an expression to the InitialToggleState property of the textbox that's displaying the +/- icon. Otherwise it will become very confusing. The icon unfortunately does not automatically reflect the row's visibility.