Export Excel

Stimulsoft Reports.JAVA discussion
Post Reply
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Export Excel

Post 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.
Attachments
Report.rar
(56.04 KiB) Downloaded 203 times
image 3.png
image 3.png (61.91 KiB) Viewed 4266 times
image 2.png
image 2.png (41.72 KiB) Viewed 4266 times
image 1.png
image 1.png (34.59 KiB) Viewed 4266 times
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Export Excel

Post by Lech Kulikowski »

Hello,

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

Thank you.
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Re: Export Excel

Post by Manuel Costa »

good morning, attached the report mentioned in the topic.
Attachments
R_RAZAO manue.mrt
(22.29 KiB) Downloaded 228 times
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Export Excel

Post by Lech Kulikowski »

Hello,

Sorry for the delay with the response.

Please send us the test data for your report.

Thank you.
Manuel Costa
Posts: 72
Joined: Thu Sep 24, 2020 2:40 pm
Location: Brazil

Re: Export Excel

Post by Manuel Costa »

Hi, so the data for testing that I'm using the columns store values ​​of type NUMBER for example 1.25
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: Export Excel

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply