creating dashboard using reporting service

Question

User-1396781667 posted

Hi Friends

 I am working on dashboard in reporting services 2005. I will give you an example of what i intend to achieve. Say in a hockey game 'n' no of teams are participating. I need a bar graph of each team displaying 'Total games' played as well as total 'Games won'.

I have certain questions:

1. Is it possible to create 'Chart' control via C# ??

2. How to deal with my requirement. Do i need only 1 rdlc file or equivalent to no of teams playing(as in example).

3.Do i need n no of charts??

Please suggest your ideas with possible solution .

i m stuck :-( !!

Cheers...

Answer 1

User-1136466523 posted

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>

From your description, it seems that you want to display each team’s participating number and wining number, right?

<o:p> </o:p>

1.       Is it possible to create 'Chart' control via C# ??

I think you have to use vb expression language in reporting service to create or control the chart control.

<o:p> </o:p>

2.       How to deal with my requirement. Do i need only 1 rdlc file or equivalent to no of teams playing(as in example). .Do i need n no of charts??

<o:p> </o:p>

I think you only need one rdlc report and one bar chart control to achieve that. See, you can get the two fields called participating and wining from your database, each row has the corresponding data for each team. Then, add two series groups in chart properties, meantime, add the corresponding category groups, values for each series.

<o:p> </o:p>

Thanks.

 

Answer 2

User-1396781667 posted

Hi

Thanks for the reply.

I think you only need one rdlc report and one bar chart control to achieve that. See, you can get the two fields called participating and wining from your database, each row has the corresponding data for each team. Then, add two series groups in chart properties, meantime, add the corresponding category groups, values for each series.

Actually in this case the final report that renders doesnt look like a dashboard. SO although it gives me the correct info but doesnt solve my purpose. I need to get the 'Total No' as well as 'Winning No' for each team shown in different charts. 

So i am not sure as if how to go for it.??

Shall i create different report viewers for each team and associate one single rdlc file to the report viewers??

Is that possible or any other way out???

Thanks n Cheers!! 

 

Answer 3

User-729066664 posted

hi,i'm new in creating dashboard report using visual c# 2010.

Appreciate if you can help to provide some basic tutorial/sample of that.

Answer 4

User-1194888170 posted

Hi,

Check these links out for a starting point:

https://www.shieldui.com/blogs/bootstrap-dashboard

http://demos.shieldui.com/sample-apps/sales-dashboard

http://geekswithblogs.net/Shieldui/archive/2013/08/29/153880.aspx

The ShieldUI framework has a rich set of components for a dashboard, available in different languages and technologies like JavaScript, ASP.NET, ASP.NET MVC and Java.