Page 1 of 1

use form filters and SQL queries together

Posted: Mon Dec 13, 2021 1:06 pm
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.

Re: use form filters and SQL queries together

Posted: Mon Dec 13, 2021 2:08 pm
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?

Re: use form filters and SQL queries together

Posted: Tue Dec 14, 2021 12:19 am
by Lech Kulikowski
Hello,

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

Thank you.