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 |
|
blinton25
Yak Posting Veteran
90 Posts |
 Posted - 2003-10-01 : 22:12:34
|
| Hello,How are you today?I used a Pivot Table to generate a Cross Tab report, and then inserted a number of calculated fields. I wish to export the Pivot Table to Excel for formating and printing purposes, but when I do this the calculated fields are not shown in the Excel sheet. From this link:http://dbforums.com/t319982.htmlit appears that not all Calculated Total fields can be exported. This seems like a strange limitation, but even when I tried printing via a Virtual printer driver the calculated fields are not exported.Is there anyway to achieve export of the calculated fields? |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-10-02 : 09:07:55
|
| Have you tried creating a query using the crosstab as the source (FROM crosstab) and calculating the fields in the query and basing your report on that?orPerforming these calculations in Excel? |
 |
|
|
blinton25
Yak Posting Veteran
90 Posts |
Posted - 2003-10-02 : 11:16:03
|
| Hello,I will try the calculation in the query approach, hopefully it doesn't affect the performance significantly.I am just suprised at the fact that such a limitation would exist for the Pivot Table, since it should be relatively simple to look at your results and add formulae as needed.I wouldn't want to carry out the calculations in Excel, only because I am automating the production of reports and wouldn't want to make this process overly difficult for end users. |
|
|
|
|
|
|
Pivot Table-Calculated Field not Exported to Excel