Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Reporting Services » Reporting Services 2005 Development » Dashboard report
Add to briefcase

Dashboard report Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
talk2riya15
Posted Tuesday, August 19, 2008 8:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 16, 2010 10:58 PM
Points: 14, Visits: 98
Can you please tell me how to create dashboard report by using SSRS???
Advance Thanks:)
Post #555034
nigel.c.west
Posted Tuesday, August 19, 2008 2:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 25, 2010 7:14 AM
Points: 170, Visits: 337
I 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,

Nigel West
UK
Post #555337
talk2riya15
Posted Wednesday, August 20, 2008 1:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 16, 2010 10:58 PM
Points: 14, Visits: 98
I 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.
Post #555580
nigel.c.west
Posted Thursday, August 21, 2008 2:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 25, 2010 7:14 AM
Points: 170, Visits: 337
If 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,

Nigel West
UK
Post #556889
b_boy
Posted Wednesday, September 24, 2008 11:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 25, 2011 1:45 AM
Points: 280, Visits: 837
Can you guys show how to create this dashboard?
Post #575428
cavo789
Posted Wednesday, September 24, 2008 11:48 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 21, 2010 3:25 AM
Points: 23, Visits: 93
Perhaps this article can help you : [url=http://www.mssqltips.com/tip.asp?tip=1361][/url]

Christophe
Post #575712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.