Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to create ssrs report

Answered How to create ssrs report

  • Monday, December 31, 2012 4:15 AM
     
     
    Sign In to Vote
    0

    Hi,

    I have some requirement to create ssrs report.

    who to create ssrs report when click on drill down report beside chart report will visiable depending what evere i am clicking the drill down item i want get that detail in chart report....

    who i will get  drill down second level and  depend chart report in same report..

     

All Replies

  • Monday, December 31, 2012 4:49 AM
     
     
    Sign In to Vote
    0

    You are actually asking about drill through

    Here are example of how to do drill down reports:

    http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD

    On clicking on field if you want to open a new report(chart report) then create a separate report for chart and use the action feature of SSRS to go chart report from actual report:

    http://msdn.microsoft.com/en-us/library/ms159847%28v=sql.100%29.aspx

    Regards,Eshwar.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


    • Edited by Eswararao C Monday, December 31, 2012 4:50 AM
    •  
     
  • Monday, December 31, 2012 5:17 AM
     
     
    Sign In to Vote
    0

    Thanks for gave replay.

    example:

    drill down report level

    first level country:

    second level state

    when ever i will cilck the country then i want to show  drill down and related chart in same report .

    when ever i will cilck the state then i want to show  drill down   and related chart in same report .

     
  • Monday, December 31, 2012 6:22 AM
     
     
    Sign In to Vote
    0

    Hello,

    See this link

    http://ssrs2008.blogspot.in/2010/09/creating-drill-down-report-with-sql.html


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan

     
  • Monday, December 31, 2012 7:07 AM
     
     Proposed
    Sign In to Vote
    0

    Hi subbu542,

    As your need , you can create chart in columns of group and subgroup as:

    Please take a look on these useful link:

    http://svangasql.wordpress.com/2011/11/14/how-to-add-sparkline-in-ssrs/

    http://www.mssqltips.com/sqlservertip/2193/getting-started-with-sparklines-in-sql-server-2008-r2-reporting-services/

    and for create drill down char:

    http://blogs.msdn.com/b/seanboon/archive/2009/02/09/enabling-drilldown-on-ssrs-reporting-services-2008-charts.aspx

    Regards Avanish T


    • Edited by Avanish Tomar Monday, December 31, 2012 7:09 AM
    • Proposed As Answer by Avanish Tomar Tuesday, January 01, 2013 12:33 PM
    •  
     
  • Tuesday, January 01, 2013 7:46 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi Subbu,

    I have tested it on my environment, the steps below are for your reference.

    1. Design a chart report to display the detail data.
    2. Drag a matrix control to the design surface.
    3. Drag the chart to the column.
    4. Drag state to the first column and then add a parent for the state field. Parent group is country field.
    5. Right click state in the Row Groups pane and select Group Properties.
    6. Go to Visibility tab and check “Hide” and “Display can be toggled by this report item”, then select “Country” in the drop-down list.

    The report looks like below.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support