Creating reports and dashboards | Stimulsoft community forum

Hi sir,

I would like to find answers regarding this scenario.

I have a report that its SQL datasource is using a stored procedure. And its content uses a temp table at its source. At first, I cannot retrieve it, but when I add this sql statement: I am able to retrieve the columns needed.

Then, when I'm using preview of the windows app. All of the data I need appears.
But when I'm using it on web preview. There are data that it is missing:
I would like to know how to prevent this and if there are some things to do when I'm using a temporary table on my SQL Datasource.

Thanks.

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

Hi sir,

Tried checking it again and it is now working. Don't know how it happens, maybe I should clear cache or something.

By the way, thanks for the concern.

Hello,

Yes, the issue could be in cache.
We are always glad to help you.

Thank you.