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.
use form filters and SQL queries together
use form filters and SQL queries together
- Attachments
-
- Untitled2.jpg (30.11 KiB) Viewed 737 times
-
- MonagheseBa filterZaman3.mrt
- (18.04 KiB) Downloaded 118 times
-
- Untitled.jpg (114.15 KiB) Viewed 740 times
Re: use form filters and SQL queries together
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?
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 (59.18 KiB) Viewed 732 times
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am