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

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/

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/

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/

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

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

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

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.

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.

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.

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...

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...

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...

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, SenthilSorry, 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.aspxThis 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

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, SenthilSorry, 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.aspxThis 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

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, SenthilSorry, 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.aspxThis 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

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 MexMex Mex India TNChe .... now in the first reporti 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

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 MexMex Mex India TNChe .... now in the first reporti 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?

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 MexMex Mex India TNChe .... now in the first reporti 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?

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 MexMex Mex India TNChe .... now in the first reporti 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?

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

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