Stimulsoft Report Preview - Missing Data

[junixquiaoit]

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:

Code: Select all

 SET FMTONLY OFF 

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.

pic1.png (86.16 KiB) Viewed 1963 times

But when I'm using it on web preview. There are data that it is missing:

pci2.png (68.18 KiB) Viewed 1963 times

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.

[Alex K.]

Hello,

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

Thank you.

[junixquiaoit]

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.

[HighAley]

Hello,

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

Thank you.