Error Stimulsoft.Report.StringList

Сonversation on different topics
Post Reply
SylvainFortia
Posts: 1
Joined: Wed Dec 27, 2017 10:03 am

Error Stimulsoft.Report.StringList

Post 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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Error Stimulsoft.Report.StringList

Post 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.
Post Reply