Jump to content
Changes to the Jaspersoft community edition download ×

polubothusatish
Go to solution Solved by polubothusatish,

Recommended Posts

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

 

 

Link to comment
Share on other sites

  • Replies 1
  • 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...