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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy