How to use the Query In function
How to use the Query In function
I have a variable with the list option, so the user can select witch item the want to see.
When the user select one item the result is ok, but with more items there are no results.
To use this variable i use the Data Source Query. Only how to select the variable correctly into the where option.When the user select one item the result is ok, but with more items there are no results.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to use the Query In function
Hello,
In this case, you can use ToQueryString() method for List variable.
Thank you.
In this case, you can use ToQueryString() method for List variable.
Thank you.
- Attachments
-
- ListInQuery.mrt
- (7.06 KiB) Downloaded 200 times
Re: How to use the Query In function
Thx for the reply.
Now i get the next Error.
Now i get the next Error.
to your MariaDB server version for the right syntax to use near '\' \') GROUP BY
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to use the Query In function
Hello,
We couldn't reproduce the issue. Please send us your report with test data for analysis.
Thank you.
We couldn't reproduce the issue. Please send us your report with test data for analysis.
Thank you.
Re: How to use the Query In function
See the attachment for my report issue.
- Attachments
-
- ListInQuery MySql.mrt
- (46.71 KiB) Downloaded 133 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to use the Query In function
Hello,
Please send us a test data for your report.
Thank you.
Please send us a test data for your report.
Thank you.
Re: How to use the Query In function
Hi,
I have made a .csv file with some data that i want to use for this report.
The idea is very simple. The user select which item the want to see on the report. Only the IN function is for this not working.
I hope someone can help me with this.
I have made a .csv file with some data that i want to use for this report.
The idea is very simple. The user select which item the want to see on the report. Only the IN function is for this not working.
I hope someone can help me with this.
- Attachments
-
- Testdata.csv
- (8.74 KiB) Downloaded 125 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to use the Query In function
Hello,
The modified report in the attachment.
Thank you.
The modified report in the attachment.
Thank you.
- Attachments
-
- ListInQuery MySql2.mrt
- (6.4 KiB) Downloaded 137 times
-
- Annotation 2019-02-15 101806.jpg (73.01 KiB) Viewed 3394 times
Re: How to use the Query In function
Thank You.
Still i get the error
'ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\' \')' at line 1'
I have not changed your report file and added the csv data as own new database.
I use the 'Stimulsoft Reports V 2019.1.1 from 17 december 2018' it is the Apple version.
So i have no idea why it is not working by me.
I use as database the program Sequel Pro.
Still i get the error
'ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\' \')' at line 1'
I have not changed your report file and added the csv data as own new database.
I use the 'Stimulsoft Reports V 2019.1.1 from 17 december 2018' it is the Apple version.
So i have no idea why it is not working by me.
I use as database the program Sequel Pro.
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to use the Query In function
Hello,
Please clarify how do you run the sample report, step by step.
Thank you.
Please clarify how do you run the sample report, step by step.
Thank you.