Creating reports and dashboards | Stimulsoft community forum

I set the SQL in the Query Text of Designer
=> SELECT * FROM loaninfo where id = {loanid}

This parameter {loanid} is created by myself. When I preview the report in the designer, it gets the error
"Report Rendering Message.
Parser error: The name 'loanid' does not exist in the current context".

But it can work if I run through PHP on URL
http://localhost/lms/reports/stimulsoft ... iable1=ABC EFG&loanid=3

Is any mistake in my report? Thanks.

Hello,

You should create a report variable with the same name, and set its default value.

Thank you.

Hello,

The problem is solved.

Thank you so much.

Great!

Have a great day!
Thank you.