How to set parameter and run in the report designer / through php?

Stimulsoft Reports.PHP discussion
Post Reply
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

How to set parameter and run in the report designer / through php?

Post by Super Bread »

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.
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

How to set parameter and run in the report designer / through php?

Post by Vladimir »

Hello,

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

Thank you.
Super Bread
Posts: 36
Joined: Mon Aug 08, 2011 12:51 am

How to set parameter and run in the report designer / through php?

Post by Super Bread »

Hello,

The problem is solved.

Thank you so much.
Andrew
Posts: 4108
Joined: Fri Jun 09, 2006 3:58 am

How to set parameter and run in the report designer / through php?

Post by Andrew »

Great!

Have a great day!
Thank you.
Post Reply