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 |
|
joe8079
Posting Yak Master
127 Posts |
 Posted - 2012-07-06 : 19:51:28
|
| If you have access to reporting services to create a matrix, do you really need to use a dynamic pivot table? I'm just wondering because I use a matrix in a lot of my reports and have never used a dynamic pivot table but I see a lot of people using them. Is there something that a dynamic pivot can do that an SSRS Matrix cannot? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-06 : 23:11:43
|
| you dont need to use pivot then. matrix does the dynamic pivot for you.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-07-07 : 04:03:30
|
| its more general than that.If you have an external application reading your results then there should be no need for a dynamic pivot - you should pivot in the application layer. You will need to parse the results anyway and pivoting is easy.Dynamic pivots are a hack.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-07-07 : 10:58:17
|
| just wanted to make sure I wasn't missing anything because I always use a matrix when I need to pivot something dynamically. I guess dynamic pivots are good if you don't have access to reporting services. Yes, dynamic pivots are very ugly looking. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-07 : 16:37:24
|
quote:
Originally posted by joe8079
just wanted to make sure I wasn't missing anything because I always use a matrix when I need to pivot something dynamically. I guess dynamic pivots are good if you don't have access to reporting services. Yes, dynamic pivots are very ugly looking.
yep...makes sense for most scenarios------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
general question