polubothusatish
-
Posts
33 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by polubothusatish
-
Can you explain to me if I had to add it to the respiratory in JasperServer: would I write it like: $X(IN, p.INTERNAL_NAME, PROVIDERNAME) OR $X(IN, p.CODE, ProviderCODE)
-
Thank You, it worked!
-
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 results for the report does work properly in Jasper Studio but when uploading JRXML in Respoistory it either gives me a blank result or errors.
-
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 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
-
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 --JOIN UNU.GEO_ZIPS GZ on G.KEY=GZ.GEO_KEY WHERE PA.GEO_KEY='&GEOKEY' Order by P.INTERNAL_NAME,WEIGH
-
SELECT p.INTERNAL_NAME "Provider Name", G.DESCRIPTION "Geo Name", GT.DESCRIPTION "Geo Type", GZ.ZIP_KEY "Associated Zip Code", PA.AMOUNT "Adjustment Amount", PA.WEIGHT "Adjustment Weight", PAT.DESCRIPTION "Adjustment Type", p.IS_ADULT "Adult Flag", p.CODE "Provider Code" FROM UNU.PROVIDER P JOIN UNU.PROVIDER_ADJUSTMENTS PA on P.KEY=PA.PROVIDER_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 JOIN UNU.GEO_ZIPS GZ on G.KEY=GZ.GEO_KEY WHERE P.INTERNAL_NAME='&PROVIDERNAME' or P.CODE='&ProviderCODE' GO
-
How to write the where clause for this query in Jasper Studio: 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 --JOIN UNU.GEO_ZIPS GZ on G.KEY=GZ.GEO_KEY WHERE PA.GEO_KEY='&GEOKEY' Order by P.INTERNAL_NAME,WEIGHT
