Jump to content

mismatched input '$P!{__#param1}' expecting ')'


cek.i06go

Recommended Posts

select count(distinct case when (o.id is not null $P!{__#param1}  $P!{__#param2} ) then o.id end) as Number, o.typefrom OST owhere o.type is not nullgroup by o.typeorder by o.type[/code]

when i write this query in my data set, JasperStudio indicate me this error:

mismatched input '$P!{__#param1}' expecting ')'

and i can't execute the report.

I'm sure that the content of param1 and 2 it's ok (and if i remove one of them, the query work).

How i can resolve this?

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

translated, the select query is this:

SELECT count(DISTINCT CASE WHEN ((o.id IS NOT NULL)  AND (o.activate BETWEEN (TO_DATE('01/01/2014', 'dd/mm/yyyy')) AND (TO_DATE('26/02/2014', 'dd/mm/yyyy')))  AND ((o.validate BETWEEN (TO_DATE('23/01/2014', 'dd/mm/yyyy')) AND (TO_DATE('20/02/2014', 'dd/mm/yyyy'))) AND o.play LIKE 'Close')) THEN o.id END) AS number, o.type[/code]

and i have always the same error... why??

Link to comment
Share on other sites

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...