Jump to content
Changes to the Jaspersoft community edition download ×

Jasper report and query in query


2004 IR Help

Recommended Posts

By: nanoua4 - nanoua4

Jasper report and query in query

2004-10-21 02:24

Hello,

i use a query as this:

select * from engagements where

( ENGAGEMENTS.ID_TIERS in (select TIERS.ID_TIERS

FROM TIERS WHERE TIERS.CODE_TIERS like $P{p_code_tiers} )),

an error is generated Sql exception ...

 

Thanks for help

 

 

 

 

By: Rick Millar - rmillar

RE: Jasper report and query in query

2004-10-21 08:45

I assume that you've tested your query outside of i-reports and it works fine. If so, then try putting an exclamation point after the "P" in your parameter reference: $P!{p_code_tiers}.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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