Export Excel
Posted: Wed Oct 14, 2020 7:01 pm
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.
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.