January 29, 2014 at 8:01 am
I have some users that are exporting a report to excel so that they can do further analysis using a pivot table. The issue that they are running into is when exporting this data from the report excel is reading all the columns as text eventhough some of these are dates and others are numbers. The pivot table in turn then can't do the normal number calculations like sum or average without the user going through and identifying all of the data after the export.
Does anyone have an idea of how during the export the report could tell excel what type of column the data is?
February 12, 2014 at 12:47 pm
Seems like I may have answered my own question, or at least half of the question. I found a few reports that were working as expected and another one that wasn't.
After comparing the differences, the ones that were working had the report column set to pull data from a database column that was an integer. As for the one that wasn't working, the data was being placed into a temp table for more complex calculations and queries but the columns that these integers were placed in where varchar columns. We switched the temp table columns to integers and these came across correctly into Excel.
However, since we're still on SQL 2005 the date doesn't work so well since it's datetime and not just date. Has anyone figured out how to make dates work for exporting into Excel to be used in analytics/pivot tables?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply