Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
???
Starting Member
3 Posts |
 Posted - 2011-06-08 : 01:22:25
|
| Dear All Experts, I'm know a little bit about SSRS parameter ,but i'm confuse about change chart type, it's that have the way to do parameter that change chart type more than 2 parameters ,Example change pie chart to bar chart or change bar chart to line chart ,so i need to know how to do parameter change chart type with SSRS 2008 or Do you have any suggestion post the method back to me please? That's very kind of you.Thank you very much for your advanced.??? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-08 : 09:32:06
|
| Well...I don't think what you want to do is possible but there is the possiblility of hacking it. What you can basically do is to create both charts and the set the charts visibility property based on the parameter value. Not very fancy but it will work.- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
???
Starting Member
3 Posts |
Posted - 2011-06-09 : 22:01:30
|
| Thank you Very much Sir. May i ask one more question SSRS is that have anyway to do animation or dynamic report like report that made from jquery? or SSRS it's just plan report picture that cannot show animate.Thanks for Advanced.??? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-10 : 02:12:54
|
| I don't know jQuery but the only way to get animations in SSRS is to use animated gif's and I'm pretty sure that's not what you want. There are however numerous 3rd party tools available that provide this functionality (some using silverlight, others using flash and maybe even html5). Here's one example, although I haven't used it so I can't say anything about the quality: http://www.perpetuumsoft.com/Downloads.aspx?lang=en&pid=116- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
???
Starting Member
3 Posts |
Posted - 2011-06-10 : 04:12:49
|
| Thank you very much for your help Sir, so if i want to do dynamic graph i should use third party like silverlight right? ,if i just use only SSRS that from BIDS it cannot do change chart ,but it's only way to do that you give me an advice that Show/Hide Graph when choose parameter report. Anyway ,That's very Kind of you. Thank you for your help.??? |
|
|
|
|
|
|
How to do SSRS parameter Change Chart Type?????