SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Dashboard report


Dashboard report

Author
Message
talk2riya15
talk2riya15
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 98
Can you please tell me how to create dashboard report by using SSRS???
Advance ThanksSmile
nigel.c.west
nigel.c.west
SSC Veteran
SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)

Group: General Forum Members
Points: 256 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
talk2riya15
talk2riya15
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 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.
nigel.c.west
nigel.c.west
SSC Veteran
SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)SSC Veteran (256 reputation)

Group: General Forum Members
Points: 256 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
b_boy
b_boy
SSC-Addicted
SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)SSC-Addicted (451 reputation)

Group: General Forum Members
Points: 451 Visits: 953
Can you guys show how to create this dashboard?
cavo789
cavo789
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 93
Perhaps this article can help you : [url=http://www.mssqltips.com/tip.asp?tip=1361][/url]

Christophe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search