Creating reports and dashboards | Stimulsoft community forum

Hello,

I just started creating reports using Stimulsoft and I really like it. However I'm having difficulties using parameters in data sources when connection via odbc (I'm connecting to oracle databases).

When I insert a parameter for a database query there are the following error messages (both on testing the statement und previewing the report)

when connecting to oracle database:
ERROR [HY000] [Oracle][ODBC][Ora]ORA-00936: missing expression

when connecting to sql server database:
ERROR [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Die "@datum"-Skalarvariable muss deklariert werden.
ERROR [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Anweisung(en) konnte(n) nicht vorbereitet werden.

However when using parameters with an sql connection on a sql server database it works.

Can you help me with this problem? It seems to me, that processing the parameters with the odbc driver does not work correctly.

Many thanks and best regards,
Raik

Hi Raik,

Please try to use unnamed parameters:

?

or variables as parameters.

Please read more on that here:

Named parameters:
http://www.stimulsoft.com/livedemos/Rep ... eters.html

Unnamed parameters:
http://www.stimulsoft.com/livedemos/Rep ... ers_2.html

There is another method of sending parameters using of the report variable. This method is suitable in case if non of named (@myparameter) or
unnamed (?) parameters worked as it was discussed here:
http://forum.stimulsoft.com/Default.aspx?g=posts&t=504


Thank you.

Thanks for your quick reply. It's working with unnamed parameters.

Hi Raik,

You are very welcome.

Please let us know if you need any help.

Thank you.