Jump to content
Changes to the Jaspersoft community edition download ×

missing EOF at Parameter


alberto.hernandez

Recommended Posts

Hi there, could you help me kindly with this error "missing EOF at $P!{valArticle} ",  I get this error in the sql editor with the following query:

 

SELECT * FROM  View1
WHERE Date BETWEEN $P{date1} AND $P{date2}  
$P!{valArticle} 
$P!{valOt} 
$P!{valCed}
 

The value expression for  $P!{valArticle}  is the following:
($P{article}.isEmpty()==true ? "" : " AND ArtCode='" + $P{article} +"'" )

 

The value expression for  $P!{valOt}  is the following:
($P{ot}.isEmpty()==true ? "" : " AND Ord_OT='" + $P{ot} +"'" )


The value expression for $P!{valCedula} is the below:
($P{cedula}.isEmpty()==true ? "" : " AND EmployeeIDReceives='" + $P{cedula} +"'" )

 

thanks for your help

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...