A service from Red Gate

in
Home SQL .NET SysAdmin Opinion Blogs Forums Books About
Sign in | Join | Help
Home Blogs Forums

Drill Down the Charts in SSRS 2005

Last post 04-25-2009, 1:50 AM by bhuvana.konduru@pbsystems.com. 2 replies.
Sort Posts: Previous Next

  •  03-16-2009, 2:19 AM Post number 72485

    Drill Down the Charts in SSRS 2005

    Reply Quote

    Hi!

    How can Drill Down the Chart in SSRS(SQL Server Reporting Services).Please explain step by step.... I'm using SQL Server 2005.

     

  •  03-24-2009, 12:29 AM Post number 72592 in reply to post number 72485

    • Dips is not online. Last active: 06-09-2009, 10:39 AM Dips
    • Top 500 Contributor
    • Joined on 02-21-2009
    • Pune India
    • Level 1: Deep thought

    Re: Drill Down the Charts in SSRS 2005

    Reply Quote
    Drill Down Report Steps
    For creating the Drill Down Report (DDR) you must have the hierarchical structure in the database.
    Here I assume that you have the hierarchical structure in the DB as follows.

    A Highest group
    B subgroup under A as B1,B2,B3...
    C subgroup under B as C1,C2,C3...
    D subgroup under C as D1,D2,D3...
    E subgroup under D as E1,E2,E3...


    1) First define how the grouping you want
    2) Prepare the query with all the groups.
    3) Using the query create the report.
    3) In the report creates the report groups (A,B,C,D,E)
    4) For getting the DDR we must put the values of group 1 level upper in the group.
       Ex. In the report group A we put the values of group B,
           In the report group B we put the values of group C,
           In the report group C we put the values of group D and so on.
    5) Now add the graphs in the report group and assign the values to the graph.
    6) After finishing the step 5, add the bookmark for the graph.
        You can add the bookmark as
        Right click on the graph on which you want to add the graph.
        Select Property.
        Go to the data tab.
        Click on the values to edit.
        In the Edit Chart value, go to the Action tab.
        Select the Jump to bookmark radio button.
        Add the bookmark.
    7) Add any text field in the group created in the report.
    8) Copy the Bookmark added in the chart and paste to the next groups text fields Bookmark ID.
    7) Repeat the steps 5 to 8 for all the reports.

    I think this will help you for creating the Drill Down Report.
    Please revert if you have any queries.

  •  04-25-2009, 1:50 AM Post number 73256 in reply to post number 72592

    How to create charts with values based on grouping conditions

    Reply Quote

    I have to create chart with values based on grouping conditions. I have multiple groups in the report.

    One group is Sales Rep

    Second group is CustomerName

    Based on the above 2 groups i need to create the chart with values based on the grouping conditions.

    The chart should show the values only for that particular salesRep and customer name.

    But for me it is showing all values in the chart irrespective of the group.

    Please provide me the procedure to be done. Any help will be appreciated.

     

     
View as RSS news feed in XML