locked
How to create Dashboard reports using SSRS? RRS feed

  • Question

  • Hi Folks,

     

      I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?

     

       Is there anyother resources avilable to develop this dashboard reports? thanks in advance..

     

     

    Thanks,

    Senthil

    Monday, March 24, 2008 12:31 PM

Answers

  •  senthil_mca80 wrote:

    Thanks again for your reply. How can i add more datasset in one report. I want to add 3 different type of data set in to one page. how can i do that?. also I have another question.

     

    I have the following data in my data set

     

       country  state  City

       USA      FL      Jax

       UK        LON   LON

       Mex      Mex    Mex

       India     TN       Che

       ....

     

    now in the first report i am creating tree view structure of the above data. Like this

     

    USA

           FL

    UK

          LON

    India

          TN..

     

               When i am clicking states (FL,LON,...) it should pass the City as a parameter to the sub report.  City should be hidden in the first report.  How can i do this...

     

    Thanks in advance

     

    Thanks,

    Senthil

     

    multiple datasets:

    go to the data-tab in your reporting project. click the dataset dropdown-button above your sql-statement. then click on <new dataset> ;-)

    you can now name the dataset and enter the sql-statement. the dataset appears in the dataset-window in the report-layout.

     

    city hidden/passing parameters:

    open the properties of state-field. then navigate to the navigation-tab and choose hyperlink action. choose the report from the dropdown menu. then click on parameters to the right and enter a parameter name and choose the field you'd like to pass through. In this case the field would be city.

     

    Hope that helps?

    Tuesday, March 25, 2008 12:39 PM

All replies

  • What exactly do you understand as dashboard. If you want to display multiple tables from different data sources on one page with additional graphics and color coding, then yes, you can create those dashboards with SSRS!

    Some useful links:
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3/
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-4/



    Monday, March 24, 2008 12:34 PM
  •  

    Hi Pete,

     

         Thanks for your reply. Yes I want to create the dashboard with chart,color . I could not access part3 and part4. i have read the first two link . It was good. can you please provide some other useful links?

     

    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3/
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-4/

     

    Thanks,

    Senthil

    Monday, March 24, 2008 1:01 PM
  • Hi.

    There arn't any dashboard by default in SSRS.
    You can only use simple graphs.

    If you want to add
    dashboard you need to use third partty component like DUNDAS (google it. Its cost money. a lot of money).

    Roy.

    Monday, March 24, 2008 1:01 PM
  • Yes, that's correct, quite expensive ;-)

    But you can create look-a-like dashboards by setting up multiple tables and graphics in one report. The interactivity of the data access and the use of parameters for each table is limited though... I use some kind of dashboard for our marketing department, displaying turnover, brand status, interactive sorting, additional customer informations in different tables with different charts and subreports as well as drill-down functionality to explore detail data. Looks pretty good If you ask me and our marketing department is very satisfied, too!

    If you have further questions, feel free to contact me...
    Monday, March 24, 2008 2:51 PM
  •  senthil_mca80 wrote:

     

    Hi Pete,

     

         Thanks for your reply. Yes I want to create the dashboard with chart,color . I could not access part3 and part4. i have read the first two link . It was good. can you please provide some other useful links?

     

    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3/
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-4/

     

    Thanks,

    Senthil



    Sorry, the links were wrong, here are the correct links for part 3 & 4 plus some other resources:

    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3-the-chart-control/
    http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-reporting-services-part-4/
    http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/
    http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

    This link is the product documentation and provides all basic infos and functions that are needed to start with SSRS and SQL server in general:
    http://msdn2.microsoft.com/en-us/library/ms130214.aspx

    Monday, March 24, 2008 3:56 PM
  • Thanks again for your reply. How can i add more datasset in one report. I want to add 3 different type of data set in to one page. how can i do that?. also I have another question.

     

    I have the following data in my data set

     

       country  state  City

       USA      FL      Jax

       UK        LON   LON

       Mex      Mex    Mex

       India     TN       Che

       ....

     

    now in the first report i am creating tree view structure of the above data. Like this

     

    USA

           FL

    UK

          LON

    India

          TN..

     

               When i am clicking states (FL,LON,...) it should pass the City as a parameter to the sub report.  City should be hidden in the first report.  How can i do this...

     

    Thanks in advance

     

    Thanks,

    Senthil

    Tuesday, March 25, 2008 12:29 PM
  •  senthil_mca80 wrote:

    Thanks again for your reply. How can i add more datasset in one report. I want to add 3 different type of data set in to one page. how can i do that?. also I have another question.

     

    I have the following data in my data set

     

       country  state  City

       USA      FL      Jax

       UK        LON   LON

       Mex      Mex    Mex

       India     TN       Che

       ....

     

    now in the first report i am creating tree view structure of the above data. Like this

     

    USA

           FL

    UK

          LON

    India

          TN..

     

               When i am clicking states (FL,LON,...) it should pass the City as a parameter to the sub report.  City should be hidden in the first report.  How can i do this...

     

    Thanks in advance

     

    Thanks,

    Senthil

     

    multiple datasets:

    go to the data-tab in your reporting project. click the dataset dropdown-button above your sql-statement. then click on <new dataset> ;-)

    you can now name the dataset and enter the sql-statement. the dataset appears in the dataset-window in the report-layout.

     

    city hidden/passing parameters:

    open the properties of state-field. then navigate to the navigation-tab and choose hyperlink action. choose the report from the dropdown menu. then click on parameters to the right and enter a parameter name and choose the field you'd like to pass through. In this case the field would be city.

     

    Hope that helps?

    Tuesday, March 25, 2008 12:39 PM
  • Hi Guys,

     

    I have the same task to do, but the links are dead. The links given above if i click shows

    404 - File or directory not found.

    The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

     

    Does anybody have updated links or mirror links that would be helpful for me.

     

    Thanks,

    FunBI

    Thursday, July 28, 2011 9:44 PM
  • Hi,

    You can use different kind of charts and graphs on a single ssrs report to create a dashboard. These charts can also be inter linked.

    you can  read my  blog to achieve the same :

    http://blogs.msdn.com/b/mind_talks/archive/2012/03/06/creating-a-drilldown-dashboard-with-ssrs.aspx

    Cheers

    Priyanka

    Thursday, March 22, 2012 2:26 PM
  • Links are not worknig man...do something
    Thursday, July 12, 2012 10:03 AM