use form filters and SQL queries together

Stimulsoft Ultimate discussion
Post Reply
faraday
Posts: 7
Joined: Mon Nov 22, 2021 8:42 am

use form filters and SQL queries together

Post by faraday »

Hi everyone,
I want to use filters of an external form instead of the internal variable of Stimulsoft. already can do it by "exec sp_executesql @Filters" on the SQL query of the Data Source. the problem is when I want to use it in a Data Source that has some SQL queries already. how can I use these together without having errors?
The report file and the image are attached.
Attachments
Untitled2.jpg
Untitled2.jpg (30.11 KiB) Viewed 709 times
MonagheseBa filterZaman3.mrt
(18.04 KiB) Downloaded 116 times
Untitled.jpg
Untitled.jpg (114.15 KiB) Viewed 712 times
faraday
Posts: 7
Joined: Mon Nov 22, 2021 8:42 am

Re: use form filters and SQL queries together

Post by faraday »

I run this by declaring a variable as shown in the image but it doesn't work properly. in fact, filters are shown in form but don't affect the output of the report.
I think it causes by SQL query, how should I edit these two queries so that the output of filters goes as input of second part queries?
Attachments
Untitled3.jpg
Untitled3.jpg (59.18 KiB) Viewed 704 times
Lech Kulikowski
Posts: 6240
Joined: Tue Mar 20, 2018 5:34 am

Re: use form filters and SQL queries together

Post by Lech Kulikowski »

Hello,

Please send us your request with detailed description on support@stimulsoft.com.

Thank you.
Post Reply