kitakura

What is the connection expression for usnig JNDI on subreport? I tried this but it did not work... java.sql.DriverManager.getConnection("jdbc/dwh")

I am currently using JS 3.0 with Oracle 10G which works fine. But would it work OK with Oracle 11? Please let me know. Thanks!

I am not sure if this will help you but when I implemented OAM (Oracle Access Management) and Acegi, I had to create custom AuthenticationProcessingFilter and UserDetailsService. Check out SiteminderAuthenticationProcessingFilter as an example. http://www.acegisecurity.org/acegi-security/xref/org/acegisecurity/ui/webapp/SiteminderAuthenticationProcessingFilter.html Good luck!

I was wondering the same thing and I think I finally figured out reading below page: http://static.springsource.org/docs/Spring-MVC-step-by-step/part1.html I could be wrong but here is what I did. I use JS 3.1 and maybe different for other JS version. But here it is: * Create hello.jsp and put it in /jasperserver/WEB-INF/jsp/hello.jsp * Add following line in /jasperserver/WEB-INF/jasperserver-servlet.xml in <bean id="handlerMapping" -- <prop key="/hello.html">MyControl</prop> * Add following line in /jasperserver/WEB-INF/jasperserver-servlet.xml in <bean id="paramResolver" -- <prop key="/hello.html">hello</prop> * Add following line in very bottom of /jasperserver/WEB-INF/jasperserver-servlet.xml before "</beans>" <bean id="MyControl" class="com.mycompany.control.MyCommonController"/> (Attached is a final version of jasperserver-servlet.xml after above changes.) * Create a class com.mycompany.control.MyCommonController (see the code below) Restart your app then click on http://XXXXXX/jasperserver/hello.html Code: Post Edited by kitakura at 12/18/2009 21:13

I could be wrong but I think you can. 1. Create a subreport 2. Main report's subreport properties, use Connection/Data Source Expression like below: java.sql.DriverManager.getConnection("jdbc:oracle:thin:@//XXXXXX:1521/XXXX", "username", $P{param_password}) 3. Make a Parameter "param_password" and set to always prompt I have not tested it...

I was able to do it... Please see below thread. http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=37515

I don't know if my approach is correct but I wrote custom granter to suit my project. Here is a sample: Code: Post Edited by kitakura at 10/14/2009 14:37 Post Edited by kitakura at 10/14/2009 14:39

Ok, so I used below string to use multiple data sources in iReport. it.businesslogic.ireport.util.Misc.getConnection("repo:/datasources/datasourcename") For JasperServer, use below: java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/dbname", "jasperdb", "password") If you are using different driver(oracle for main and mysql for other), you will need to create scriptlet. Please see below thread: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=44794&topid=44890 Good luck! Post Edited by kitakura at 09/02/2009 00:22

I use SimpleDateFormat as an reference and it seems to work. I tried "HHmmss" without colon and worked fine.

I finally figured out why this was not working. When I use my custom report option jsp page, it does not work.

I am not sure if JS 3.1 has same problem but in JS 3.0, when you try to schedule (or email) a report with multi-select report option, it errors. Does it work for you?

My JavaScript skill is not very good but here is what I did. Maybe you can use it as a reference. 1. Added JavaScript Check() in jasperserver_directory/scripts/view-report.js (Please see below code section) 2. Added new SelectAllParamtersForm.jsp in jasperserver_directory/WEB-INF/jsp directory. (Please see below code section) 3. Go to JasperServer web interface as Administrator, click on check box next to the report. Select "Edit" from top menu. Report Wizard should come up. Click on Controls & Resources from left. Enter SelectAllParamtersForm.jsp in Optional JSP location. Click Finish and Save. You should see "Select all/un-Select all" option on top of multi-select report option. Good luck! Kassie JavaScript Code for view-report.js Code: SelectAllParamtersForm.jsp (same as DefaultParametersForm.jsp but added Check() in multi-select option) Code: Post Edited by Super Monkey at 01/29/09 14:26

Is there any plan to add Ad Hoc reports in community version? Thanks!

It happends at 2 places at web interface. I first click on check box on the report has multi-select query report option. 1) click on the icon with envelopes (Run in backgroung....) 2) click on the icon with clock then click on "Schedule Job" button

Hi, I am trying to schedule report which has an input control, multi-select query (Collection). Trying to do this gives me an error. Does anyone know how to fix this problem? Thanks! Kassie Code:org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: Invalid key [null] in model Map: only Strings allowed as model keys org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:408) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)root causejava.lang.IllegalArgumentException: Invalid key [null] in model Map: only Strings allowed as model keys org.springframework.web.servlet.view.AbstractView.exposeModelAsRequestAttributes(AbstractView.java:293) org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:116) org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) javax.servlet.http.HttpServlet.service(HttpServlet.java:690) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)