Hi, i have generated report in ssrs 2008 based on grouping of columns. but the requirement is when the report is shown only first column has to be shown and when we drill down into only first and second column has to shown and when we further drill down the other columns along with 1 and 2 columns has to be shown. any help is appreciated . Please help me. Thanks

In the group properties set the visibility property to toggle by an item. http://msdn.microsoft.com/en-us/library/ms156456.aspx

Hi, Refer below link for info, they have mentioned on SSRS 2005, however same you can implement on SSRS 2008 as well. http://www.mssqltips.com/tip.asp?tip=1329Nanda

thanks a lot for ur help. but i need to hide columns not rows . can u please help in this.

Hi venkat, thanks a lot fro ur help. But i had already seen that link. i cant find the solution for my requirement. here in this case i need to hide columns. Thanks.

Hi Sql-developer, If the columns are static column, I think your requirement might not be able to achieved currently. So here I would recommend you submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Regards, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.