Creating reports and dashboards | Stimulsoft community forum

Hello,I'm trying to write a sql command like this: That @name is a parameter.
But I don't know How to write this in stimule soft report.
please help me to write that statement.

Thank you.

Hi Maria,

Please write the following expression in the SQL Editor window:

select * from employee where name Like @name

And define a parameter:

@name

The parameter value must be as follows:

@name = "%myparametervalue%"

Thank you.

Hello Edward,
I did the following:
I’m write the expression such as expression you wrote and then I’m define a parameter named: % @name %
Then I do the following in my code:
report.DataSources["Employee"].Parameters["% name %"].ParameterValue = "%" + txtName.Text.ToString() + "%";

but I get the following Error.

Incorrect syntax near '%'.
Must declare the scalar variable "@name".
Statement(s) could not be prepared.

In Line:
Line 22: report.DataSources["Employee"].Parameters["% @name %"].ParameterValue = "%" + txtName.Text.ToString() + "%";
Line 23: StiWebViewer1.Report = report;


Please help me to fix the error.

Thank you.

Hi Maria,

Excuse me for my typing error and not clear explanation of the required steps.

Everything you did is correct.

Just change the name of the parameter. Right-click in the '% @name %' parameter (it is an incorrect name for the parameter) and change its name as follows:

@name

Then your query must work.

Thank you.

Hi Edward,
The program Worked.

Thank you very much:biggrin:

Hi Maria,

You are very welcome Have a nice day!

Thank you.