carolopia

Can I create a report for me Jaspersoft to generate the information directly into a file without having to display information on the screen? I have a very heavy report that the number of records is difficult to display it , I need to generate a file to be downloaded locally. Is this possible? Regards, Carolina Rojas.

Hello Everybody, I have a problem when I try to export to excel some report, this is the error: The server has encountered an error. Please excuse the inconvenience. Error Messagecom.jaspersoft.jasperserver.api.JSException: jsexception.too.many.data.rows Error Tracecom.jaspersoft.jasperserver.api.JSException: jsexception.too.many.data.rows The report contains around 100.000 rows or more, but I need necesarily export this report to excel, What can I do???? Please help me! Thanks in advance, Regards, Caro.

Thanks for your answer, now I want to know how can I download this file to the file system? I was trying with a query like "select data from jicontentresource where id = 1198 into outfile '/user/temp " but when I execute it fail, this is the log: " [sELECT - 0 row(s), 0.000 secs] [Error Code: 1045, SQL State: 28000] Access denied for user 'jasperdb'@'%' (using password: YES)" Somebody knows What can I do?? Thanks in advance, Regards, Caro.

Hello everyone, I have schedule to many reports to generate the result into a Excel in a folder of Jasperserver. Where are this reports? are in the data base? If are in the database in what table? or are in some file system? I need to put this Excel into a file system, how can I do this? thanks in advance, Regards, Caro.

Hi Everyone, I was trying to create a new parameter "java.sql.Connection" with the default expression is like that "java.sql.DriverManager.getConnection("jdbc:postgresql://192.185.10.84:5432/server", "postgres", "passwq")" I pass this new parameter to my subreport like connection expression, when I run the master this fail, the error is: Error filling print... Error evaluating expression :     Source text : java.sql.DriverManager.getConnection("jdbc:postgresql://192.185.10.84:5432/server", "postgres", "passwq") Setting up the file resolver... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :     Source text : java.sql.DriverManager.getConnection("jdbc:postgresql://192.185.10.84:5432/server", "postgres", "passwq")     at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195)     at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)     at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)     at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:636)     at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:585)     at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1280)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.sql.SQLException: No suitable driver found for jdbc:postgresql://192.185.10.84:5432/server     at java.sql.DriverManager.getConnection(DriverManager.java:602)     at java.sql.DriverManager.getConnection(DriverManager.java:185)     at java_sql_DriverManager$getConnection.call(Unknown Source)     at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)     at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)     at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132)     at subReporteKasadosPadre_1310046814012_28500.evaluate(calculator_subReporteKasadosPadre_1310046814012_28500:147)     at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182)     ... 13 more I need your help to fixed this, Thanks in advance, Regards, Caro.Â

hello everyone, I have a report with two subreports, but this subreports have a diferents datasources of master report. How can I pass or define this ones datasources? thanks in advance, Regards, Caro.

Hello Everybody, I have in my report a barcode field but I don't know how Can I align that. I was trying but I can't do it. When I preview my report the barcode always print to the left, but I need print this in the center. Somebody knows how can I do it? Thanks, Regards. Caro.

hello everybody, I have a report with a field that is a Date and I need to put other field with this date but adding to hours more. Somebody knows how Can I do it? Thanks, Regards. Caro.

Thanks, It works.. /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

hello everyone, I have a report in Jasperserver, but when I want to export to a excel file this export are without tittles of the columns. how can I fixed this issue? Thanks for all your help, Regards Caro

Thanks for your help. I owe you one. I will search information in the Jasperserver forum. I hope find something that can it help me because is hard to change JasperServer to other application that I have many reports in JasperServer in production. Again thanks for your help, Regards from Colombia. Caro.

It works perfect, thanks!!!! Now I need other issue, I need put this report in the JasperServer, I do this perfectly but what about the file? How can a user edit this one with the data to the query? Can they edit this file? thanks! Regards. Caro.

Hello everyone, I trying to do the same of this topic and I am follow the indications, create a new List parameter, use $X in this way $X{IN, pan, CLIENTE}, I have a default value for the parameter but when I run the report this is the output net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. Parameter type not supported in query : CLIENTE class java.util.List I am use oracle. This is my query: select i.barcode, t.opendate, t.name, t.pan, t.client_address, t.client_phone, i.quantity, i.amount, i.unitamount, t.pos, t.localid, t.ticketnumber from tickets t join ticketitems i on (t.pos = i.pos and t.localid = i.localid and t.ticketnumber = i.ticketnumber) where $X{IN, pan, CLIENTE} order by t.opendate Any idea?? Thanks in advance, Caro.

Thanks jpauze for your help. I need the data of the file to pass a SQL query, the query is like "select b, d, f from a where c in ("here put the data of the file") " I use Jasperserver to integrate this report and I need pass the file as a parameter. I don't know if is posible do this. Regards, Caro.

Hi everyone, Can I use a file as a parameter in a report? If I can, How can I do this? The file is a txt with information in this style: 123455 123445 512555 125255 Thanks for your help! Regards, Caro.

It's important that you know when I run the report appear a message "this report is empty" and not have errors, but how you see the xml has data. I hope you can help me. Regards, Caro.

Hi everyone, Can I use a file like a parameter in a report? If I can, How can I do this? The file is a txt with information in this style: 123455 123445 512555 125255 Thanks for your help! Regards, Caro.

Hi everyone, I am trying to make a report with xml datasource, I do step by step following this tutorial http://www.adictosaltrabajo.com/tutoriales/tutoriales.php?pagina=ireportXml , It works fine with the example in the tutorial, but when I am trying with my xml doesn't work. This is an example of my xml, <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://service.geopromotion.geocom.com.uy/"> - <xsl:template match="MsgData/Transaction">- <importPromotions>- <xsl:for-each select="CK_POS_EVENT_WS">- <arg0 xmlns="">- <promotionList>+ <id> <xsl:value-of select="DESCR_LN6" /> </id>- <promotionHead>+ <period>+ <startDate> <xsl:value-of select="DESCR1" /> </startDate>+ <endDate> <xsl:value-of select="DESCR2" /> </endDate>+ <startTime> <xsl:value-of select="DESCR3" /> </startTime>+ <endTime> <xsl:value-of select="DESCR4" /> </endTime> <days>254</days> </period> <name>test</name> <description>test</description> <enabled>true</enabled> <typeID>SALE</typeID>- <categoryID> <xsl:value-of select="EVENT_ID" /> </categoryID>- <priority> <xsl:value-of select="SEQ_NBR" /> </priority> </promotionHead>+ <ways> <id>0</id> <wayName>Camino por defecto</wayName>- <conditions> <id>0</id> <elementID>transaction</elementID> <negative>false</negative>- <filters> <id>0</id> <fieldID>financePlanField</fieldID> <operatorID>equalString</operatorID> <value>TEST</value> <negation>false</negation> </filters> </conditions>- <percentageDiscountAppliers> <id>0</id>- <productCondition> <id>0</id> <elementID>productLine</elementID> <negative>false</negative>- <filters> <id>0</id> <fieldID>skuField</fieldID> <operatorID>equalString</operatorID>- <value> <xsl:value-of select="INV_ITEM_ID" /> </value> <negation>false</negation> </filters> </productCondition> <toQuantity>false</toQuantity> <quantity>0.0</quantity> <unitPrice>false</unitPrice>- <percentage> <xsl:value-of select="ADJ_PCT" /> </percentage> </percentageDiscountAppliers> </ways> </promotionList>- <promotionTypeList> <eliminated>false</eliminated>- <name> <xsl:value-of select="DESCR_LN1" /> </name> <promotionLevel>1000</promotionLevel> <updated>2009-12-13T14:26:58.772-02:00</updated> </promotionTypeList> </arg0> </xsl:for-each> </importPromotions> </xsl:template> </xsl:stylesheet> Can somebody help me? Regards, Caro.

Thanks, It works for me!!! /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

Hi everyone, I have a report where the dataset comes from a SQL but I need to choose the where clause from a parameter. For example if the user choose in the parameter "ALL" then the where clause is " Where fieldA = 'X' " but if the user choose in the parameter "B" then the where is "where fieldB = 'Y'" How can I do this? Is posible? thanks. Regards. Caro.

Not, I can't, because I have the XML in a database in postgres and this XML have some information that I neet to put in my report. /tools/fckeditor/editor/images/smiley/msn/sad_smile.gif

Hi everyone, I have to do a query from oracle where one field have a type bytea, this field is a XML with some information. I need in a report take this XML and draw some of the information that have this XML to make my report, this report have some fields of the query and others fields from this XML (remember that the XML is one field of the query) what can I do? Please help me. Thanks a lot. Regards. Caro.

hello everyone, I have one report and different datasources, this datasources have the same estructure but are in different locations and I need generate the same report for every datasource. I have the report in jasperserver because the users can access to look these ones. Can I create some kind of parameter with the connections to datasources and the users choose these ones depends that they need? or how can I resolve my problem? Have I to create the report in jasperserver for every datasources? Important to know: The users don't have administrator permissons. thanks for all your help. Regards, Caro.