dsmithsonhome

Hi. Suppose I want to specify a date range using input controls. The dates are in MySQL datetime format: Code:yyyy-mm-dd hh:mm:«»ss. I've decided I will use two inputs, MaxTime and MinTime or something like that. The two parameters will feed into a third parameter which constructs the WHERE clause for the SQL query. Question is, how do I specify the pattern in the input control to get the datetime format that MySQL will understand? Post edited by: dsmithsonhome, at: 2006/08/24 02:43

Thank you! This is exactly what I needed. It works perfectly. :)

Ah, I see. Am I correct in thinking that this type of select will allow us to get a list of stuff from a query? For instance, a list of 'Users' or 'Queues' that live in a MySQL table. :)

Suppose I have an input control that controls the value of a parameter that is referenced in a WHERE SQL clause, that can be either defined or not defined. Is that possible? In other words, suppose I have a SQL query that references $P{something}, but if $P{something} is undefined, I want the SQL WHERE part to be ignored. Perhaps I'm doing this the wrong way, but is it possible to put a condition somewhere that checks whether the parameter is defined before the SQL query is executed?

Hi. Is the Single Select Query for an input control currently implemented? JI 1.0.1 iReports 1.2.4 w/JI plug Code:org.apache.jasper.JasperException: Exception in JSP: /WEB-INF/jsp/inputControls/queryDescription.jsp:68 65: <tr> 66: <td colspan="3"><div align="center"><strong>Please enter Query description information:</strong></div><BR></td> 67: </tr> 68: <spring:bind path="control.inputControl.query.name"> 69: <tr> 70: <td><div align="right"><strong>Name:</strong></div></td> 71: <td colspan="2"><input name="${status.expression}" maxlength="100" type="text" class="fnormal" size="20" value="<c:out value='${status.value}'/>"><c:if test="${status.error!=null}"><BR><span class="ferror">${status.errorMessage}</span></c:if></td> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:111) org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250) org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:813) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) javax.servlet.http.HttpServlet.service(HttpServlet.java:709) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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:136) 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) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) 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) root cause org.springframework.beans.NullValueInNestedPathException: Invalid property 'inputControl.query' of bean class [com.jaspersoft.jasperserver.war.dto.InputControlWrapper]: Value of nested property 'inputControl.query' is null org.springframework.beans.BeanWrapperImpl.getNestedBeanWrapper(BeanWrapperImpl.java:397) org.springframework.beans.BeanWrapperImpl.getBeanWrapperForPropertyPath(BeanWrapperImpl.java:372) org.springframework.beans.BeanWrapperImpl.getBeanWrapperForPropertyPath(BeanWrapperImpl.java:373) org.springframework.beans.BeanWrapperImpl.getPropertyValue(BeanWrapperImpl.java:478) org.springframework.validation.BindException.getFieldValue(BindException.java:341) org.springframework.web.servlet.support.BindStatus.<init>(BindStatus.java:117) org.springframework.web.servlet.tags.BindTag.doStartTagInternal(BindTag.java:115) org.springframework.web.servlet.tags.RequestContextAwareTag.doStartTag(RequestContextAwareTag.java:68) org.apache.jsp.WEB_002dINF.jsp.inputControls.queryDescription_jsp._jspService(queryDescription_jsp.java:110) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:111) org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250) org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1047) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:813) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) javax.servlet.http.HttpServlet.service(HttpServlet.java:709) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) 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:136) 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) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195) 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)

More messing around: If I add the image via the web interface, it shows as a 'gear' in iReports. If I add the image through iReports, it shows as an 'image' and I'm able to add the image to the report. So, the problem is sort of solved.

More on this: If I add an image to a sub folder, such as 'Images', it appears in the jasper server plugin as an icon of a gear. If I add the image inside a report unit folder, it appears as an icon of an image. I can drag and drop the image icon into the report, but it still doesn't compile, complaining that: net.sf.jasperreports.engine.JRException: Image not found : repo:/RT/Test/logo Is "repo:/RT/Test/logo" the correct way to call an image from the server repository?

Hi all. I have iReport 1.2.4 with the jasperserver plugin. I have the JasperIntelligence package installed and working on a Linux server. I can't seem to add objects from the server to a report in iReport. For instance, I've added image to the server, drag and drop to a report results in nothing. Thanks.