raquel

when I tried to write idOferta, I realised my server wasn't updating the report!! The query ... AND ($P{IdOferta} = '0' OR OFERT_ID IN ($P!{IdOferta}) ) ... was ok and parameters too. Thanks for all the replies.

It could be Jasper thinks options a) and b) contains only one number? a)1234 b) 1234,5678 (where 5678 are decimals) this way, c) is not a valid number.... how can I solve it?

Hi I have a String parameter that is put with "in operator" on SQL. The query has (beetwen others) the following clauses: where ... AND ($P{IdOferta} = '0' OR OFERT_ID IN ($P!{IdOferta}) ) ... my code: ... String idOferta = req.getParameter("idOferta"); // java.lang.String if (idOferta != null && !idOferta.equals("") && !idOferta.equals("")){ parameters.put("IdOferta",idOferta); } ... The problem is: a) when I have idOferta=1234 everything is ok b) when I have idOferta=1234,5678 there is no running error c) when I have idOferta=1234,5678,9012 I get the following error: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : myReport]: java.sql.SQLException: ORA-01722: invalid number Any suggestion? Thanks in advance.

I have de same problem. Did you find the solution? Thanks.

I have the same error passing a Set in the Collection Type parameter

Hi, I get the following errors when exporting report to xml in my spring based application: (a) the iexplorer opens the excel sheet but it causes an error which makes iexplorer closes and restarts (b) the iexplorer opens a blank page and i get the following trace in my console: [16/10/08 18:31:46:918 CEST] 32ec65f9 SystemOut O ****************************** fin del controler [16/10/08 18:31:51:715 CEST] 32ec65f9 TraceNLS u No message text associated with key HttpConnection.run:.java.lang.IllegalStateException:.0.response.bytes.written,.but.Content-Length.header.equals.73216 in bundle com.ibm.ejs.resources.seriousMessages [16/10/08 18:31:51:715 CEST] 32ec65f9 HttpConnectio E HttpConnection.run: java.lang.IllegalStateException: 0 response bytes written, but Content-Length header equals 73216 [16/10/08 18:31:51:715 CEST] 32ec65f9 SystemOut O java.lang.IllegalStateException: 0 response bytes written, but Content-Length header equals 73216 [16/10/08 18:31:51:715 CEST] 32ec65f9 SystemOut O at com.ibm.ws.http.HttpResponse.finish(HttpResponse.java:99) [16/10/08 18:31:51:715 CEST] 32ec65f9 SystemOut O at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:681) [16/10/08 18:31:51:715 CEST] 32ec65f9 SystemOut O at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:435) [16/10/08 18:31:51:715 CEST] 32ec65f9 SystemOut O at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) First time I get the first error (a). then I kill the msexcel.exe proccess that remains running with no excel window. And next time I execute I get the error (b). This occurs when I export to xls (calling jasperXml view) If I export to html (calling jasperHtml view) everithing is ok. Here is my code: * jasper-server.xml: ********************** <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "utils/spring-beans.dtd"> <beans> <import resource="applicationContext.xml"/> <bean id="urlMapping" class="org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping"> </bean> <bean id="jasperController" class="hgc.web.JasperController"> <property name="dataSource" ref="dataSource"/> </bean> <bean id="viewResolver" class="org.springframework.web.servlet.view.XmlViewResolver"> <property name="location" value="/WEB-INF/views-jasper.xml"/> </bean> </beans> * views-jasper.xml: ********************* <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "utils/spring-beans.dtd"> <beans> <bean id="jasperXls" class="org.springframework.web.servlet.view.jasperreports.JasperReportsXlsView"> <property name="url" value="/jsp/pruebas/jasper/Global_Operational_Report.jasper"/> <property name="jdbcDataSource" ref="dataSource"/> <property name="exporterParameters"> <map> <entry key="net.sf.jasperreports.engine.export.JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS"> <value>true</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN"> <value>false</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET"> <value>false</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_DETECT_CELL_TYPE"> <value>true</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND"> <value>false</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN"> <value>true</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_IGNORE_GRAPHICS"> <value>true</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS"> <value>true</value> </entry> </map> </property> </bean> <bean id="jasperHtml" class="org.springframework.web.servlet.view.jasperreports.JasperReportsHtmlView"> <property name="url" value="/jsp/pruebas/jasper/Global_Operational_Report.jasper"/> <property name="jdbcDataSource" ref="dataSource"/> <property name="exporterParameters"> <map> <entry key="net.sf.jasperreports.engine.export.JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS"> <value>true</value> </entry> <entry key="net.sf.jasperreports.engine.export.JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN"> <value>false</value> </entry> </map> </property> </bean> </beans> * JasperController: ********************* public class JasperController extends BaseController{ /*Spring Injection*/ private DataSource dataSource; public void setDataSource(DataSource dataSource) { this.dataSource = dataSource; setCacheSeconds(-1); } //carga el componente lateral de express public ModelAndView jasperReport(HttpServletRequest request, HttpServletResponse response, HttpSession session) throws Exception{ ModelAndView mav = new ModelAndView("jasperXls"); //KO //ModelAndView mav = new ModelAndView("jasperHtml"); //OK try{ Map model = new HashMap(); model = getModel(request,model); model = recogerParametroIdioma(request,model); model.put("dataSource",dataSource); System.out.println("model="+model); System.setProperty("java.awt.headless","true"); System.setProperty("awt.toolkit", "com.eteks.awt.PJAToolkit"); System.setProperty("java.awt.graphicsenv", "com.eteks.java2d.PJAGraphicsEnvironment"); System.setProperty("com.eteks.awt.nojava2d", String.valueOf(true)); } catch(Exception e){ throw Funciones.doException(this, e, session); } System.out.println("****************************** fin del controler"); return mav; } private Map getModel(HttpServletRequest req, Map parameters){ //add report parameters... parameters.put("key","value"); return parameters; } private Map recogerParametroIdioma(HttpServletRequest req, Map parameters){ // ****************************** idioma e i18n java.util.Locale localeVar = null; String idioma = req.getParameter("idioma"); System.out.println("idioma="+idioma); int separacion = idioma.indexOf("_"); String idIdioma = idioma.substring(separacion+1,idioma.length()); idioma = idioma.substring(0,separacion); System.out.println("localeVar="+localeVar); System.out.println("idioma="+idioma); System.out.println("idIdioma="+idIdioma); if (idioma != null && !idioma.equalsIgnoreCase("")){ localeVar = new java.util.Locale(idioma, ""); System.out.println("localeVar="+localeVar+"-->"+localeVar.getLanguage()); } java.util.ResourceBundle resourceBundle = ResourceBundle.getBundle("jsp.pruebas.jasper.literales",localeVar); parameters.put(JRParameter.REPORT_LOCALE,localeVar); parameters.put(JRParameter.REPORT_RESOURCE_BUNDLE,resourceBundle); parameters.put("idIdioma",new Integer(idIdioma)); System.out.println("idIdioma="+idioma); System.out.println("resourceBundle="+resourceBundle); return parameters; } } Any suggestion? Thanks in advance. Code:

Yes, the formula is right. I set the reset group to my group and it worked and calculation=none and incrementType=none. I need a variable because I need it's value for other calculations. Thanks for your reply.

Hi. 1. I have a table (named my_table_amount, for instance) in my DB with these fields (between others): amount_EUR (BigDecimal) amount_GBP (BigDecimal) amount_USD (BigDecimal) myGroupingFieldand my query is select * from my_table_amount The report shows all the records grouping by myGroupingField. For each value of myGroupingField I have one or two records with the same amount_EUR, amount_GBP and amount_USD, so I show all the values in group footer 2. I have a parameter in my report named $P{currency} whose values are (1,2,3) : 0: EUR (euros) 1: GBP (pounds) 2: USD (US Dolar)The type could be Integer or String. 3. The question: I need a variable named $V{amount} (BigDecimal). I want its value to be: if $P{currency} = 1then $V{amount}=$F{amount_EUR} if $P{currency} = 1then $V{amount}=$F{amount_GBP} if $P{currency} = 3then $V{amount}=$F{amount_USD}for each record in the table. How can I set the values for $V{amount}? I don't know what I have to set in each variable field (resetType, resetGroup, calculation, variableExpression, initialValueExpression) I have the folowing expression but it returns null: ( $P{currency}.intValue()==0 ? $F{amount_EUR} : ( $P{currency}.intValue()==1 ? $F{amount_GBP} : ( $P{currency}.intValue()==2 ? $F{amount_USD} : new BigDecimal("0") ) ) )

Do you men something like this? http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=44207