vstoyak Posted April 1, 2009 Share Posted April 1, 2009 I am trying to customize input control JSP page to use cascading parameters. And looking for some help/explanations.I have three elements Country, State, City defined as popup elements populated by single select queries method. I was able to modify default parameter JSP page so that after each popup element changed it refreshes itself and preserve selections by passing them as HTTP parameters. However when i try to use these parameters $P{p_state} (for example) in "single select query" to shortlist cities based on selected STATE, I get the following error. It seems like single select query does support parameters however it refuses to verify it for whatever reason (I do have "p_state" parameter defined in my JRXML template). Am I missing something obvious here, any hint or help on how to make my parameters to work inside single select queries? Any workaround, in case it is a known bug?Thanks a lot,Vladimir net.sf.jasperreports.engine.JRRuntimeException: Parameter "p_state" does not exist.net.sf.jasperreports.engine.JRRuntimeException: Parameter "p_division" does not exist. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.checkParameter(JRAbstractQueryExecuter.java:476) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.appendParameterChunk(JRAbstractQueryExecuter.java:244) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.appendQueryChunk(JRAbstractQueryExecuter.java:217) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.parseQuery(JRAbstractQueryExecuter.java:197) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.<init>(JRJdbcQueryExecuter.java:94) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:128) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:53) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:112) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:1039) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:998) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.executeQuery(ReportParametersAction.java:514) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:477) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:414) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:123) at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:148) at sun.reflect.GeneratedMethodAccessor500.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) Link to comment Share on other sites More sharing options...
anandharaj Posted April 2, 2009 Share Posted April 2, 2009 Yes, query in input control does not support the parameter, there were some workaround in this forum (you need to change the java code and compile again the JS), i'll search and post the link here. Link to comment Share on other sites More sharing options...
anandharaj Posted April 2, 2009 Share Posted April 2, 2009 http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=53671&page=1 Link to comment Share on other sites More sharing options...
vstoyak Posted April 2, 2009 Author Share Posted April 2, 2009 Thanks you! Yes, I saw that post and was glad to see LoggedInUsername parameter working however unfortunately I am not a Java developer and probably would not be able to implement java code changes myself and/or recompile it. So I will be looking for someone's else services to help me with that (implementing so that defined variables in input control queries will be substituted with values of corresponding HTTP parameters). If someone on this list could help with that, please drop me email on vstoyak@yahoo.com. Thanks,Vladimir Link to comment Share on other sites More sharing options...
anandharaj Posted April 2, 2009 Share Posted April 2, 2009 I think our developer already implemented "workaround" in different manner, but not sure whether that will be available in up-coming JS-3.5 or not.. Link to comment Share on other sites More sharing options...
vstoyak Posted April 2, 2009 Author Share Posted April 2, 2009 I have installed 3.5 RC but it is not there, so my parameters (other then LoggedInUsername are not recognized). Could you please check with your developers if they are willing to share what they've implemented. Thanks a lot,Vladimir 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