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.