Excel exports don't provide adequate formatting

Tuesday, October 7, 2014
Avatar
Is there a way to export our raw data to excel?  I can only export summary data, and the formatting used when exporting via Reporting adds formatting to the file that makes it impossible to manipulate.
2 Replies
Tuesday, October 7, 2014
Avatar
re: TammyT Tuesday, October 7, 2014

Hi Tammy

You can use the MS-Excel 2003 format reports that don't contain as much of the rich text.

Otherwise I'd suggest using the custom reporting option to use a ESQL query to get the data you want in the format you want.

Regards

Adam

Tuesday, October 7, 2014
Avatar
re: inflectra.david Tuesday, October 7, 2014

Adam - 

Sorry, but I tried exporting to Excel 2003 .  The problem is that the data gets bundled into cells or added as separate lines that can't be filtered or sorted to retain all of the data for the record.  Plus, because it's summary data, we can't drill down to selected records.

Not being a SQL programmer, so am kind of at a loss as to how to get the data we need.

- Tammy

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Tuesday, October 7, 2014
  • Last Reply: Tuesday, October 7, 2014
  • Replies: 2
  • Views: 2649