Page 1 of 1

Export Excel

Posted: Wed Oct 14, 2020 7:01 pm
by Manuel Costa
So, I find myself with the following scenario, I have a report and in it there are two text components that refer to a variable, for example {value}, so when I export the report in Excel format, the information is different from that presented in application.

In each of these there are conditions for a specific calculation, in the first condition it was as shown in image 1:

v_saldo = (R_RAZAO_SETOR.VL_SALDO_MES +R_RAZAO_SETOR.VL_DEBITO) - R_RAZAO_SETOR.VL_CREDITO

In the second condition, it looks like this as shown in image 2:

v_saldo = (v_saldo + R_RAZAO_SETOR.VL_DEBITO)-R_RAZAO_SETOR.VL_CREDITO

Then, as mentioned, images of the report being displayed in the application are attached and also a .rar file, which contains the report in the formats mentioned below, which show when the report is exported in another format such as TXT, Word, HTML and Excel, is the format that presents problems. Image 3 attached to the report in the application.

And with that I would like to understand what may be happening so that when the report exported in Excel is leaving with changed data, if you can help me with this scenario.

Re: Export Excel

Posted: Mon Oct 19, 2020 9:08 am
by Lech Kulikowski
Hello,

Please send us your report template (mrt file) with test data for analysis.

Thank you.

Re: Export Excel

Posted: Mon Oct 26, 2020 2:04 pm
by Manuel Costa
good morning, attached the report mentioned in the topic.

Re: Export Excel

Posted: Fri Oct 30, 2020 8:02 am
by Lech Kulikowski
Hello,

Sorry for the delay with the response.

Please send us the test data for your report.

Thank you.

Re: Export Excel

Posted: Fri Oct 30, 2020 6:37 pm
by Manuel Costa
Hi, so the data for testing that I'm using the columns store values ​​of type NUMBER for example 1.25

Re: Export Excel

Posted: Thu Nov 05, 2020 8:04 am
by Lech Kulikowski
Hello,

Please send us a sample report that we can run and reproduce the issue.

Thank you.