The server has encountered an error. Please excuse the inconvenience.
Error Message
Order cannot be resolved because of circular or non-existing dependencies.
Error Trace
com.jaspersoft.jasperserver.api.JSException: Order cannot be resolved because of circular or non-existing dependencies. at com.jaspersoft.jasperserver.war.cascade.token.FilterCore.resolveCascadingOrder(FilterCore.java:370) at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.resolveCascadingOrder(GenericInputControlLogic.java:305) at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getValuesForInputControlsFromRawData(GenericInputControlLogic.java:224) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:173) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:165) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.callControlLogic(InputControlsLogicServiceImpl.java:221) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getValuesForInputControls(InputControlsLogicServiceImpl.java:165) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getReportParameterValuesFromRequest(ReportParametersAction.java:459) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:462) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:395) at sun.reflect.GeneratedMethodAccessor1657.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at
For the input control setting the Parameter Values:
Value Column: PA.GEO_KEY
Visible Column: PA.GEO_KEY Desc
Query I used:
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
Edit Input Control:
Type: Mult-select Query
Mandatory and Visible