polubothusatish Posted September 30, 2013 Share Posted September 30, 2013 The errors that occur are: a.) Parameter not found: GEOKEY ---net.sf.jasperreports.engine.design.JRDesignExpression@538a7e36 b.) Query parameter not found : GEOKEY ---net.sf.jasperreports.engine.design.JRDesignQuery@d4e9bd5 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...
polubothusatish Posted September 30, 2013 Author Share Posted September 30, 2013 The answer is: WHERE PA.GEO_KEY= $P{GEOKEY} 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