Hi All, I have created drill down report group on two column abd then display rest row on toggling..report is running fine, i have some issue regarding formatting the report. AS of now i have report like On clicking on PLUS sign, report drilled down as shown above. But i want when i click on PLUS sign , report will drilled down as below I.e on clicking it will show just below MAin data not drilled to side pane. Pleas help.... Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi Amit, You need to reduce the width of the column on which the grouping is done in the tablix. There is no other option in SSRS to hide that gap and then have the toggling effect shown for drill down. HTH. Regards,Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Hi Phaneendra babu Subnivas, Thanks a lot... Is there is any feasibility to the same with the help of SUBReports. Kindly SuggestAmit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi there I think you will be able to do this inside SSRS 2008 Just add a row outside group above in your tablix where the value for c and d column displayed and manipulate the value as I have shown in the figure. I hope this will help If you have any questions please let me know Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Amit, To design a report as you expect, the sbureport has to be placed in a row below the details row. As Phani posted above, if we place the subreport below the details row, there will be a gap generated when the toggle is collapsed. To minimize the influence of the gap, we need to reset some borders and resize the subreport control. The following steps are for your reference: Drag a Table control to the Design surface, delete the first row, and insert a details row. Merge the cells in the second row.Place a subreport control to the second row, set the bottom border of the first row to No Border. In the subreport design surface, set the top border of the first row to No Border.Minimize the subreport. The screenshot below shows the design structure and the report preview: If you have any questions, please feel free to let me know. Regards, Mike Yin

Hi Mike, Thanks for your reply, i already did the same.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/