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
Parameter-Binding in Reports
Parameter-Binding in Reports
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.
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.
Parameter-Binding in Reports
Thanks for your quick reply. It's working with unnamed parameters. 

Parameter-Binding in Reports
Hi Raik,
You are very welcome.
Please let us know if you need any help.
Thank you.
You are very welcome.
Please let us know if you need any help.
Thank you.