View Data Doesn't Work when using Parameters

Stimulsoft Reports.JS discussion
Post Reply
AcidSlide
Posts: 8
Joined: Sat Aug 14, 2021 7:46 pm

View Data Doesn't Work when using Parameters

Post by AcidSlide »

Hi,

We are having issues with the current 2021.3.6 version for the ReportJS. When dealing with SQL based datasource (MySQL and MSSQL), the View Data doesn't work when the SQL uses parameters;

For example:

This works View Data returns a data:
select * from `shipment_cost` where ReferenceNbr='REF00012345'

But this doesn't work (no data is returned in View Data):
select * from `shipment_cost` where ReferenceNbr='{ReferenceNbr}'


After further investigation we noticed the the Report Designer is sending this queryString: {"command":"ExecuteQuery","connectionString":"","queryString":"select * from `shipment_cost` where ReferenceNbr=''"} (blank even if we input a data in the popup screen requesting the ReferenceNbr value)

We know this used to work with previous versions of ReportJS (we think prior to 2021.3.x verson).

I hope you can help us out.
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: View Data Doesn't Work when using Parameters

Post by Lech Kulikowski »

Hello,

Thank you for the bug report. We need some time to fix the issue.

Thank you.
#4698
AcidSlide
Posts: 8
Joined: Sat Aug 14, 2021 7:46 pm

Re: View Data Doesn't Work when using Parameters

Post by AcidSlide »

thanks for the response.. we hope this can be resolved as soon as possible as this really helps in testing for valid data from the queries..

thanks again
Lech Kulikowski wrote: Tue Aug 17, 2021 7:03 am Hello,

Thank you for the bug report. We need some time to fix the issue.

Thank you.
#4698
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: View Data Doesn't Work when using Parameters

Post by Lech Kulikowski »

Hello,

We will let you know about the result.

Thank you.
AcidSlide
Posts: 8
Joined: Sat Aug 14, 2021 7:46 pm

Re: View Data Doesn't Work when using Parameters

Post by AcidSlide »

Hello,

Any updated regarding this?

Thanks
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: View Data Doesn't Work when using Parameters

Post by Lech Kulikowski »

Hello,

We are still working on the problem. We will let you know when the solution is available.

Thank you.
Post Reply