March 10, 2015 at 1:10 pm
Hello,
I have excel 2010 with a regular pivot table. Is there a way to covert that pivot table into t-sql code so I can plug it into SSRS. Or is there a more simple way of converting a excel pivot table into a SSRS report? Appreciate the help.
March 10, 2015 at 2:41 pm
JP10 (3/10/2015)
Hello,I have excel 2010 with a regular pivot table. Is there a way to covert that pivot table into t-sql code so I can plug it into SSRS. Or is there a more simple way of converting a excel pivot table into a SSRS report? Appreciate the help.
Assuming that you mean the MDX code from the Pivot table view in Excel...not as far as I know. The only way you may be able to get that is by running a trace.
March 10, 2015 at 4:05 pm
I tried the trace no love. It does not catch anything I can use. I read some where that in PowerPivot in excel you click on analyze\connections\properties\definition and in the Command Text it shows the pivot table query. But, I tried that as well in regular excel pivot table and I don't see the query for this. Thanks though.
March 10, 2015 at 4:42 pm
I guess my real question is there a way to publish an excel pivot table onto ssrs without having to write the sql pivot code in ssrs?
March 10, 2015 at 5:00 pm
No, Excel and SSRS are 2 very different platforms.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply