How to put input Control for the current Query?

0

Hi,

                       I am using Jasper Studio and JasperSoft for Server on Mac . I am trying to upload a JRXML file in repository and getting numorous error message say it cannot upload the file. Currently, I'm using 5.2 Jasper Studio.  The main issue is when Im trying to colunm name Input control:

How do I put Input Control for the current Query? Show I use the mult-select query or single-select Query?:

Set Parameter Values: 

Value Column:  

Visible Column: ?

 

 

SELECT 

G.DESCRIPTION "Geo Name",

GT.DESCRIPTION "Geo Type",

PA.AMOUNT "Adjustment Amount",

PA.WEIGHT "Adjustment Weight",

PAT.DESCRIPTION "Adjustment Type", 

p.INTERNAL_NAME "Provider Name",

p.IS_ADULT "Adult Flag",

p.CODE "Provider Code"

FROM UNU.PROVIDER_ADJUSTMENTS PA

JOIN UNU.PROVIDER P on PA.PROVIDER_KEY=P.KEY

JOIN UNU.ADJUSTMENT_TYPE PAT on PA.ADJUSTMENT_TYPE_KEY=PAT.KEY

JOIN UNU.GEO G on PA.GEO_KEY=G.KEY

JOIN UNU.GEO_TYPE GT on G.GEO_TYPE_KEY=GT.KEY

WHERE PA.GEO_KEY= $P{GEOKEY}

Order by P.INTERNAL_NAME,WEIGHT

 

 

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 5 years 5 months ago

1 Answer:

0

Solution: In the Input Control select single-value and chose number: and value: PA.GEO_KEY

It works properly, main important point is to use single value in the input control. 

 

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 5 years 5 months ago
Feedback
randomness