Page 1 of 2
How to use the Query In function
Posted: Wed Jan 09, 2019 10:24 am
by Martijn
I have a variable with the list option, so the user can select witch item the want to see.
- Schermafbeelding 2019-01-09 om 11.17.08.png (39.86 KiB) Viewed 5231 times
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.
- Schermafbeelding 2019-01-09 om 11.18.35.png (41.97 KiB) Viewed 5231 times
Re: How to use the Query In function
Posted: Wed Jan 09, 2019 11:14 pm
by Lech Kulikowski
Hello,
In this case, you can use ToQueryString() method for List variable.
Thank you.
Re: How to use the Query In function
Posted: Thu Jan 10, 2019 10:57 am
by Martijn
Thx for the reply.
Now i get the next Error.
to your MariaDB server version for the right syntax to use near '\' \') GROUP BY
Re: How to use the Query In function
Posted: Sun Jan 13, 2019 8:25 pm
by Lech Kulikowski
Hello,
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
Posted: Wed Jan 16, 2019 4:14 pm
by Martijn
See the attachment for my report issue.
Re: How to use the Query In function
Posted: Fri Jan 18, 2019 10:03 am
by Lech Kulikowski
Hello,
Please send us a test data for your report.
Thank you.
Re: How to use the Query In function
Posted: Thu Feb 14, 2019 4:17 pm
by Martijn
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.
Re: How to use the Query In function
Posted: Fri Feb 15, 2019 9:17 am
by Lech Kulikowski
Hello,
The modified report in the attachment.
Thank you.
Re: How to use the Query In function
Posted: Mon Feb 18, 2019 8:58 am
by Martijn
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.
Re: How to use the Query In function
Posted: Mon Feb 18, 2019 9:15 am
by Lech Kulikowski
Hello,
Please clarify how do you run the sample report, step by step.
Thank you.