Creating reports and dashboards | Stimulsoft community forum

Currently the designer preview & viewer run's the SQL twice (2020.2.2).
Using the Firebird database datasource.

I tested the issue on a few versions, using the same report, it used to work correctly until 2019.4.2.

2019.3.4 - SQL ran once
2019.4.1 - SQL ran once
2019.4.2 - SQL ran 3 times
2020.1.1 - SQL ran 3 times
2020.2.1 - SQL ran 2 times
2020.2.2 - SQL ran 2 times

The report itself seems to only generate once, but it uses data from the last SQL statement ran.

Thanks,
Barnaby.

Hello,

Please send us a sample report with test data for analysis.

Thank you.

Hey,

When I was trying to create a demo report, I found that it's only the SQL's using Variables that run twice.

I've attached a NodeJS server that returns dummy data to Stimulsoft.
Just run the NodeJS server & open localhost:8080

It will open the designer with a test report that uses 2 SQL statements, one with no variable, one using the variable.
You will see that the SQL using the variable runs twice.


Thanks.

Hello,

Please try to set the RequestParameters=true option.

Thank you.

Hi,

I'm already using that parameter, it doesn't fix the issue.
Turning it off does the exact same thing, but when you hit 'Submit' for the parameters, it then runs it again, as expected. Both times running the SQL with the Variable twice.


I noticed that I missed a file causing the demo server attached above not to run.
I've now reattached it to this.
Run the 'run server.bat' & then open localhost:8080

Thanks

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.