Export of Report to Excel

alex2u · Post by **alex2u** » Mon Oct 01, 2007 5:19 am

Hello,
I have some trouble exporting the report to Excel. I need to have the numeric data in the report displayed as numeric values in Excel as well (same goes for currency data). I have changed the properties of the data in the report from "general" to "number" but my excel sheet shows the numbers as strings.

I've already noticed that you can set the ExcelValue property, but this won't work either. Unfortunately your documentation on the ExcelValue property (online as well as offline) will give me a "page cannot be found"-error (404).

It would be great, if you could help me with this issue.

Thanks in advance, Alex

Post by **Vital** » Mon Oct 01, 2007 7:23 am

Hello Alex,

You must type in ExcelValue expression for example:

{123}
{DataSource.Value}
{var+123}
{Sum(DataSource.Value)}

In result this expression must return numeric value.

Thank you.

alex2u · Post by **alex2u** » Mon Oct 01, 2007 9:49 am

Thanks a lot for the quick response.

Numeric values are transferred to Excel now, and it also works great with currencies as well as other formats.

Alex

Post by **Edward** » Tue Oct 16, 2007 2:14 am

Let us know, if you need any help.

Thank you.

meukoh · Post by **meukoh** » Wed Jun 16, 2010 12:03 pm

If I type {Sum(DataSource.Value)} in ExcelValue, after I export to Excel is it possible to keep the SUM() function in the Excel sheet? Because now only the result of the Sum() is exported to Excel.

It would be nice to have for future upgrades.

Post by **Andrew** » Thu Jun 17, 2010 2:40 am

Hello,

Sorry, on the current moment, it is not possible.

Thank you.

LukasT · Post by **LukasT** » Tue Aug 31, 2010 7:23 am

Hello,
why this functionality is not automatic when I want to export report to excel? I mean, you can automaticaly "convert" as a part of exporting process every text field to right excel data type, because you know result data type of expression...
What do you thing about this feature?
Thank you

Post by **Ivan** » Tue Aug 31, 2010 3:13 pm

Hello,

We made some improvements in that direction about a year ago.
Please check the latest build and let us know about the result.
If the issue is still present, please send to us a mrt file with data for analysis.

Thank you.

LukasT · Post by **LukasT** » Wed Sep 01, 2010 8:04 am

Hello Ivan,
yes, this issue is still actual. You can try to export to excel simple report with one field with expression like "{1+2}". Excel has recognized this as String...

Post by **Ivan** » Wed Sep 01, 2010 2:57 pm

Hello,

Please set the TextFormat property of textbox to Number.

Thank you.