InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:47:53 GMT20http://www.sqlservercentral.com/Forums/Topic555034-1063-1.aspxPerhaps this article can help you : [url=http://www.mssqltips.com/tip.asp?tip=1361][/url]Wed, 24 Sep 2008 23:48:34 GMTcavo789http://www.sqlservercentral.com/Forums/Topic555034-1063-1.aspxCan you guys show how to create this dashboard?Wed, 24 Sep 2008 11:17:16 GMTb_boyhttp://www.sqlservercentral.com/Forums/Topic555034-1063-1.aspxIf I was creating the report I would do exactly what you are doing, I would create separate datasets for each distinct query. As you say, if you try to combine these into a single query it will be complex, and it will then make the charts more complex.So, carry on the way you're going, you seem to be doing ok.Regards,Thu, 21 Aug 2008 14:05:26 GMTnigel.c.westhttp://www.sqlservercentral.com/Forums/Topic555034-1063-1.aspxI have used 3 datasets and by using this i was able to create the dashbord and i have taken 4 chats.I want to ask is there any other process instead of that??thins is otherwise it will be a complicated query.Wed, 20 Aug 2008 01:53:14 GMTtalk2riya15http://www.sqlservercentral.com/Forums/Topic555034-1063-1.aspxI think your question is a little too general, creating a dashboard report depends on the content of the report. What do you want to show on the report?How many datasets will be used?What charts are going to be used?Then......Are all the charts covered by SSRS?If not, you might need to consider Dundas.These are just a few questions, the question could also be answered quite easily by saying that you should create a dataset to return the required information, then add a couple of charts to show that data. Very difficult to give more detail without specific questions or much more detail.Regards,Tue, 19 Aug 2008 14:06:17 GMTnigel.c.westhttp://www.sqlservercentral.com/Forums/Topic555034-1063-1.aspxCan you please tell me how to create dashboard report by using SSRS???Advance Thanks:)Tue, 19 Aug 2008 08:12:42 GMTtalk2riya15