q16marvin

i search something like that: jdbc:postgresql://192.168.1.18:5432/db?ApplicationName=Reporting($P{LoggedInUsername})&socketTimeout=60 it would be perfect to see in postgres monitor the user who exec reports: is there a way to do this?

i got it... install a postfix also on the same server like jasper runs and set jasper to this localhost... thx! Erik

i also need this!

hi, is it possible to put mails in a queue when the mail server is not available and jasperserver will sends reports again when mail server is back? Thx! Erik

Hi, i search so long, but i dont find any solution... Is it not possible to schedule some reports with a dynamic filename? For exampe testreport_26102014_blabla.csv where date is the dynamic. the dynamic part should be parsed from a paramter. thx! Erik

http://community.jaspersoft.com/jasperreports-server/issues/3255

solution: http://community.jaspersoft.com/jasperreports-server/issues/3255

here is a solution: http://community.jaspersoft.com/jasperreports-server/issues/3255

Hello, when i schedule a job with a report output format "excel no pagination" in the filename appears "*.nopag.xls". how can i remove this? Thank you!

okay here the answer: net.sf.jasperreports.export.xls.exclude.origin.band.4=columnFooter in the apache-tomcatwebappsjasperserverWEB-INFclassesjasperreports.properties has to be inaktiv!

im the only one how have this problem?

Hello, on every export i see my column footer row (sum row), only in excel is nothing shown. why? thank you!

i solved the problem, in my java class i have to set: cal.setFirstDayOfWeek(Calendar.MONDAY); because the jasperserver runs on a english windows server and the the week starts on sunday. thx!

Hello, i wrote me class to get some dates for "Yesterday,Last Week and Last Month". Yesterday and Last Month works great, but Last Week give me in jasperserver the wrong date (-1 day). in ireport works great. here is the code: if("Last Week".equals(dateChoice)){ cal.setTime(new Date()); cal.add(Calendar.WEEK_OF_YEAR,-1); cal.set(Calendar.DAY_OF_WEEK,cal.getFirstDayOfWeek()); } Why is it not working in jasperserver? i read something to set the datasource timezone to defautl, but it also stands on default ...

Yes of course i definded the controls in the setting of the report (i also have much more parameters). But the hole parameter list ist empty. after i delete the control and the parameter in ireport the report on the server works...

Hello, i want to use dynamic dates (http://community.jaspersoft.com/wiki/dynamic-dates-reports) to create a input control list with "Yesterday, Last Month,etc" I build the class and in iReprt it works great. (import the jar file). Then i deploy the report on the jasperserver and also uploaded the jar file. but now there are no visible input controls. please can you help me?

ok i have it, the problem was that the ireport paramter was from typ string, it must be integer

no i check at twice that the parameter has the right name and defautl value oh the param in ireport is the id 1, but in my list have the id's 5,6,7,8,9. and jasperservert show my everytime the id 5 in the report

Hello, i use a input control single select list, i get the values from my query (id and name). i set vor the value the id colum. now i want to select a name in the list and send the id to the report, but he only sends the "first" entry of the list. i can select what i want, but anytime he sends the id from the first value why?

okay you mean this as expression for the field? but than i get this errors: Error filling print... Error evaluating expression : Source text : String.format("%d:%02d:%02d", $F{avg_call_duration}/3600, ($F{avg_call_duration}%3600)/60, ($F{avg_call_duration}%60)) Setting up the file resolver... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : String.format("%d:%02d:%02d", $F{avg_call_duration}/3600, ($F{avg_call_duration}%3600)/60, ($F{avg_call_duration}%60)) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:559) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:884) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:425) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:406) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:257) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:457) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2037) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:771)

yes of course, but then ireport is not able to build a sum over all times.

hello, my query give me seconds (for example 120). know i want to display this in the format HH:mm:ss (00:02:00). How can i do this with ireport? i cant format it in the query because i want to display a sum of the seconds also in the format HH:mm:ss thank you!