Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dashboard report Expand / Collapse
Author
Message
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
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
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
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
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: Yesterday @ 12:36 AM
Points: 280, Visits: 869
Can you guys show how to create this dashboard?
Post #575428
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