Creating reports and dashboards | Stimulsoft community forum

The sql in command works fine with oracle, however when i am executing the report nothing shows.

Where column_x In (:PARAM)

the paramter works fine if i pass it just a single value, however multiple values it stops working.

I suspect it has somehting to do with the parameter type, but very unsure.

Anyone else had any joy with the in command and parameters

Hi,

The following post might be able to help you:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=366

Thought that would have solved my problem however, i dont quite understand how the {parameter} works as when i run the report it gets rejected.

I am using oracle firstly so it doesn't seem to accept @ or ? only :

If i execute query in Reports.Web and enter values (multiple values) it works fine.

Its only when passing via parameter.