Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Drill Down Report Issue

Answered Drill Down Report Issue

  • Wednesday, May 09, 2012 7:58 AM
     
     
    Sign In to Vote
    0

    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/

     

All Replies

  • Wednesday, May 09, 2012 8:32 AM
     
     
    Sign In to Vote
    0

    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.

     
  • Wednesday, May 09, 2012 10:31 AM
     
     
    Sign In to Vote
    0

    Hi Phaneendra babu Subnivas,

    Thanks a lot...

    Is there is any feasibility to the same with the help of SUBReports.

    Kindly Suggest

    Amit
    Please mark as answer if helpful
    http://fascinatingsql.wordpress.com/

     
  • Wednesday, May 09, 2012 10:57 AM
    Moderator
     
     Proposed
    Sign In to Vote
    0

    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.


     
  • Thursday, May 10, 2012 1:26 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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:

    1. Drag a Table control to the Design surface, delete the first row, and insert a details row. Merge the cells in the second row.
    2. 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”.
    3. 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

     
  • Tuesday, May 15, 2012 7:26 AM
     
     
    Sign In to Vote
    0

    Hi Mike,

    Thanks for your reply, i already did the same.

    Amit
    Please mark as answer if helpful
    http://fascinatingsql.wordpress.com/