While downloading reports in JRS the numeric fields are downloaded as text. Can this be eradicated?
One answer
The report data passed from JRS to Excel for a live query is in XML format. When I implemented the export of the XML data for Excel I tried to include formatting (such as creating a hyperlink for the resource name/URI in Excel) but I could not find a way to make it work. Excel only seems to store text values when parsing the XML data.
However, there are several things you might try (I am not an Excel expert so these may not work)
1) In the Query Results tab, after updating the results, select the column and change its type to numeric.
2) In a different tab create a numeric column that extracts the (text) values from the Query Results table using the =VALUE() function to convert the values to numbers. Then have your pivot table use this numeric column instead.
However, there are several things you might try (I am not an Excel expert so these may not work)
1) In the Query Results tab, after updating the results, select the column and change its type to numeric.
2) In a different tab create a numeric column that extracts the (text) values from the Query Results table using the =VALUE() function to convert the values to numbers. Then have your pivot table use this numeric column instead.