viewer shows wrong data / relations don't work in PHP viewer
viewer shows wrong data / relations don't work in PHP viewer
Hi,
My report shows wrong data in the viewer. It works fine in the designer. I use 2019.4.2.
The issue is visible in the enclosed image.
Based on extensive experimenting I can tell the issue is related to the use of variables and/or relations.
I think it is an old problem which was solved in previous versions, but somehow came up again.
Could you please help.
Enclosed you find the mysql script files, the report.mrt and the publish package.
Best regards, André
[update] The attachment files have been sent to support@stimulsoft.com by WeTransfer
My report shows wrong data in the viewer. It works fine in the designer. I use 2019.4.2.
The issue is visible in the enclosed image.
Based on extensive experimenting I can tell the issue is related to the use of variables and/or relations.
I think it is an old problem which was solved in previous versions, but somehow came up again.
Could you please help.
Enclosed you find the mysql script files, the report.mrt and the publish package.
Best regards, André
[update] The attachment files have been sent to support@stimulsoft.com by WeTransfer
- Attachments
-
- Show-Report-Php-Pack.zip
- (4.66 MiB) Downloaded 228 times
-
- stimultestdb.txt
- (3.83 KiB) Downloaded 238 times
-
- Report.mrt
- (15.96 KiB) Downloaded 218 times
-
- left_viewer-wrong-and_right_designer_okay.png (264.17 KiB) Viewed 4157 times
Last edited by andreb on Sat Dec 21, 2019 12:04 pm, edited 4 times in total.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: viewer shows wrong data
Hello,
We couldn't find your files.
Please send us your request with a detailed description on support@stimulsoft.com or provide ticket number.
Thank you.
We couldn't find your files.
Please send us your request with a detailed description on support@stimulsoft.com or provide ticket number.
Thank you.
Re: viewer shows wrong data
Hi Lech,
The files have been attached to the original post. (The uploading failed previously but now I managed to upload the files)
The report is in the report file report.mrt.
The mysql database can be created by using the script in stimultestdb.txt.
The show-report-php-pack is the file which has been created when I publish.
When you preview the report in the designer it shows other results than the viewer after publising.
I can't get the relations work properly in the viewer, which results in empty databands but only after publishing. Without relations, the results in designer and viewer are both okay.
You can see the issue in the picture. Left is the result in the viewer (which is wrong), right is the result in the designer (which is okay).
Hope this helps.
Best regards, Andre
The files have been attached to the original post. (The uploading failed previously but now I managed to upload the files)
The report is in the report file report.mrt.
The mysql database can be created by using the script in stimultestdb.txt.
The show-report-php-pack is the file which has been created when I publish.
When you preview the report in the designer it shows other results than the viewer after publising.
I can't get the relations work properly in the viewer, which results in empty databands but only after publishing. Without relations, the results in designer and viewer are both okay.
You can see the issue in the picture. Left is the result in the viewer (which is wrong), right is the result in the designer (which is okay).
Hope this helps.
Best regards, Andre
Re: viewer shows wrong data / relations don't work in PHP viewer
Hi Lech,
Please let me know if you need additional information regarding the issue.
So bottom line: Relations work in the designer, but not in the viewer. It does not work in 2020.1.1 either.
Best regards, Andre
Please let me know if you need additional information regarding the issue.
So bottom line: Relations work in the designer, but not in the viewer. It does not work in 2020.1.1 either.
Best regards, Andre
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: viewer shows wrong data / relations don't work in PHP viewer
Hello,
Sorry for the delay with the response.
We need some additional time to investigate the issue.
Thank you.
Sorry for the delay with the response.
We need some additional time to investigate the issue.
Thank you.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: viewer shows wrong data / relations don't work in PHP viewer
Hello,
The issue is fixed. The fix will be available in the next release build.
Thank you.
The issue is fixed. The fix will be available in the next release build.
Thank you.
Re: viewer shows wrong data / relations don't work in PHP viewer
Hi Lech,
Great , I look forward to it.
Andre
Great , I look forward to it.
Andre
Re: viewer shows wrong data / relations don't work in PHP viewer
Hello.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.
We are always glad to help you.
Let us know if you need any additional help.
Thank you.