vstoyak

Ignore my post. Me being blind. There is "Include Subfolders" checkbox for that

Have a question around this discussion. In versions prior to 3.7 Repository Viewer was showing only content of a current folder (reports, documents, etc) but in 3.7 if you click on folder it shows you ALL documents (reports, results, etc) in the current folder and recursively in ALL subfolder which mess up app Folder layout and organization of reports by subjects. Is there any option to DISABLE recursive list and do ONLY show documents that are in the current folder.

Anyone can help me to disable axes. I need to build a report where in each row of the report will be trend line "apsrkline" chart. This should be very simple visualization. I was able to put line chart into each row of the report, disable axes names and legend but there is no option to disable axes lines and values on them. Does anyone know if it can be done with custom chart styles. Basically out of line chart I only need to show line itself and nothing else. Vladimir

I am trying to implement Cascading Input Controls patch but it does not seem to work with Multi-Select Queries and it does not allow me to select any line in multi-select list (once i click on the line it deselects it right away). Anyone can help me with this? Vladimir

Can anyone comment on availability of "Cascading Parameters" feature in Input Control? Thanks a lot, Vladimir

Any update of flow control (cascading parameters) support in JasperServer? Someone mentioning few month ago that it was WIP due to be included mid-May. Anybody has information on where it stands right now? Vladimir

I am trying to export metadata using js-export.sh --everything --output-dir js_export_test.zip from 3.5RC to import into 3.5 and get the following error. Any help? Root tenant "organizations" not found, skipping tenants18:08:40,557 ERROR Cipherer:146 - java.lang.NumberFormatException: For input string: "d@"java.lang.NumberFormatException: For input string: "d@" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48) at java.lang.Integer.parseInt(Integer.java:456) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.Cipherer.dehexify(Cipherer.java:209) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.Cipherer.decode(Cipherer.java:147) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordCipherer.decodePassword(PasswordCipherer.java:119) at com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.toClient(RepoUser.java:335) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getUsers(UserAuthorityServiceImpl.java:257) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy4.getUsers(Unknown Source) at com.jaspersoft.jasperserver.export.modules.auth.AuthorityExporter.initUsers(AuthorityExporter.java:98) at com.jaspersoft.jasperserver.export.modules.auth.AuthorityExporter.init(AuthorityExporter.java:89) at com.jaspersoft.jasperserver.export.ExporterImpl.invokeModules(ExporterImpl.java:177) at com.jaspersoft.jasperserver.export.ExporterImpl.process(ExporterImpl.java:143) at com.jaspersoft.jasperserver.export.ExporterImpl.performExport(ExporterImpl.java:119) at com.jaspersoft.jasperserver.export.ExportCommandImpl.process(ExportCommandImpl.java:57) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)18:08:40,564 ERROR BaseExportImportCommand:45 - org.springframework.dao.DataAccessResourceFailureException: For input string: "d@"org.springframework.dao.DataAccessResourceFailureException: For input string: "d@" at com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordCipherer.decodePassword(PasswordCipherer.java:123) at com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser.toClient(RepoUser.java:335) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getUsers(UserAuthorityServiceImpl.java:257) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy4.getUsers(Unknown Source) at com.jaspersoft.jasperserver.export.modules.auth.AuthorityExporter.initUsers(AuthorityExporter.java:98) at com.jaspersoft.jasperserver.export.modules.auth.AuthorityExporter.init(AuthorityExporter.java:89) at com.jaspersoft.jasperserver.export.ExporterImpl.invokeModules(ExporterImpl.java:177) at com.jaspersoft.jasperserver.export.ExporterImpl.process(ExporterImpl.java:143) at com.jaspersoft.jasperserver.export.ExporterImpl.performExport(ExporterImpl.java:119) at com.jaspersoft.jasperserver.export.ExportCommandImpl.process(ExportCommandImpl.java:57) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)

Is it implemented, can i use jasperserver roles in cube. I tried it, but it does not seem to work. Anybody was able to do it?

I see the same behaviour and not able to make it use aggregates. Have you or anybody else understood what is missing and how to make it work? Thanks a lot, Vladimir

I've tried to use $X in the SQL statement of the report and it works great. The problem is when I try to use multiple value list in expression condition for "sql_adddition_string" hidden parameter to build dynamic SQL. In my case I want to implement "ALL" item in the list. p_group is defined as java.util.List sql_adddition_string is defined as java.lang.String on "sql_adddition_string" I tried the following default values expressions 1==2 ? " and 1=1" : "and $X{IN, group_id, p_group}" - DOES work and $X is properly translated into "group_id in (choice1, choice2, choice3) however when i try to use $P{p_group}.contains("ALL") ? " and 1=1" : "and $X{IN, group_id, p_group}" - it does NOT work and put "NULL" in place of $P!{sql_adddition_string} in my SQL query. Am I missing something here? Why I can not use boolean conditions on java.util.List type? Thanks a lot, Vladimir

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

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

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)