Page 1 of 1

Error Stimulsoft.Report.StringList

Posted: Wed Dec 27, 2017 11:11 am
by SylvainFortia
Hello everyone!

I came across an error which I could not solve by myself.. so here I am, would you kindly help me with this one ? :roll:

I am trying to use a Data List as a parameter to request the user to choose multiple entries for one variable. Like this:
Image
The error I get when I do the preview is this one : No mapping exists from object type Stimulsoft.Report.StringList to a known managed provider native type.
Image

How my datasource is:
Image
Image

When I do it with Value, it works, I just have to change List to Value in the parameter and the "in" to "=" in the query BreachCycles. There, I can choose only ONE entry. I would like to allow the user to choose several.
Image
Image
Image

Is that possible and I am doing it wrong or this is a bug? I precise again, I need to pull this entries from the data and not as Items

Basically, this : https://www.stimulsoft.com/en/documenta ... s_list.htm does not work for me :( !
Look forward to hearing from someone :D
Regards

Re: Error Stimulsoft.Report.StringList

Posted: Wed Dec 27, 2017 2:37 pm
by HighAley
Hello, Sylvain.

You should use the ToQueryString() method to fill the SQL query with values.
Please, read the Dynamic SQL queries article.

Thank you.