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.
Export Excel
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Export Excel
- Attachments
-
- Report.rar
- (56.04 KiB) Downloaded 266 times
-
- image 3.png (61.91 KiB) Viewed 4970 times
-
- image 2.png (41.72 KiB) Viewed 4970 times
-
- image 1.png (34.59 KiB) Viewed 4970 times
-
- Posts: 6812
- Joined: Tue Mar 20, 2018 5:34 am
Re: Export Excel
Hello,
Please send us your report template (mrt file) with test data for analysis.
Thank you.
Please send us your report template (mrt file) with test data for analysis.
Thank you.
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Re: Export Excel
good morning, attached the report mentioned in the topic.
- Attachments
-
- R_RAZAO manue.mrt
- (22.29 KiB) Downloaded 301 times
-
- Posts: 6812
- Joined: Tue Mar 20, 2018 5:34 am
Re: Export Excel
Hello,
Sorry for the delay with the response.
Please send us the test data for your report.
Thank you.
Sorry for the delay with the response.
Please send us the test data for your report.
Thank you.
-
- Posts: 72
- Joined: Thu Sep 24, 2020 2:40 pm
- Location: Brazil
Re: Export Excel
Hi, so the data for testing that I'm using the columns store values of type NUMBER for example 1.25
-
- Posts: 6812
- Joined: Tue Mar 20, 2018 5:34 am
Re: Export Excel
Hello,
Please send us a sample report that we can run and reproduce the issue.
Thank you.
Please send us a sample report that we can run and reproduce the issue.
Thank you.