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?
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 Charlie
Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
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.
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 MVP http://visakhm.blogspot.com/
general question
Posted - 07/06/2012 : 19:51:28
