polubothusatish Posted October 3, 2013 Share Posted October 3, 2013 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 PAJOIN UNU.PROVIDER P on PA.PROVIDER_KEY=P.KEYJOIN UNU.ADJUSTMENT_TYPE PAT on PA.ADJUSTMENT_TYPE_KEY=PAT.KEYJOIN UNU.GEO G on PA.GEO_KEY=G.KEYJOIN UNU.GEO_TYPE GT on G.GEO_TYPE_KEY=GT.KEYWHERE PA.GEO_KEY= $P{GEOKEY}Order by P.INTERNAL_NAME,WEIGHT Link to comment Share on other sites More sharing options...
Solution polubothusatish Posted October 7, 2013 Author Solution Share Posted October 7, 2013 Solution: In the Input Control select single-value and chose number: and value: PA.GEO_KEYIt works properly, main important point is to use single value in the input control. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now