Excel pivot tables issue
-
Montag, 26. Mai 2008 17:19
I want to build a pivot table out of the results of a stored procedure in sql 2005. The SP uses around 5 temporary tables and finally joins all of them to produce a result set. I reffered this SP while creating the pivot tables but it doesnot return data on the excel. I tried executing the SP from query analyzer and i get back the data. Is there a limitation of excel 2007 pivot tables that it cannot return data if multiple temporary tables are used in a SP in SQL 2005?
.png)
.png)
