rodrigo_43

Hi All, My question is simple, is there a way to ADD a blank row to the CSV export of a report? I need blank lines between TITLE and DETAIL bands. Thanks.

You are talking SSL to acces web instance of jasper in browser or SSL for SFTP file transfer? If first, i think maybe it's tomcat related ? If 2nd you should upload private key as Security File as admin and in scheduler it's all you need to set it up.

Reports in Studio ship with a REPORT_LOCALE parameter, what first comes to my mind is maybe you can use it to create conditional expressions.

You only show the first row of the error stack trace, show a bit more to see maybe what error actually is about

Hi all, I am trying to schedule a report in JSON using rest_v2 API. I've already added metatags on report, which has only got textfields. Error I am getting is the following: org.quartz.JobExecutionException: Did not find report result for {paginated: null,maxPageHeight: null, maxPageWidth: null} atcom.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.getReportResultForOutput(ReportExecutionJob.java:744) atcom.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:521) atcom.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:245) atcom.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:46) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) And request made to schedule such report is the following: http://{ipaddress}:8080/jasperserver-pro/rest_v2/jobs?j_username=jasperadmin&j_password=jasperadmin PUT BODY: { "label": "Customers JSON Schedule", "creationDate": "2019-05-22T22:01:00.920-03:00", "trigger": { "simpleTrigger": { "startType": 2, "startDate": "2019-05-23 10:38", "misfireInstruction": 0, "occurrenceCount": -1, "recurrenceInterval": 1, "recurrenceIntervalUnit": "DAY" } }, "baseOutputFilename": "Test1_FILENAME", "source": { "reportUnitURI": "/public/Reports/Test/Customers", "ignorePagination": true, "parameters": { "parameterValues": { "date_from": [ "2019-01-01" ] } } }, "outputFormats": { "outputFormat": [ "JSON" ] }, "repositoryDestination": { "folderURI": "/public/Reports/Outputs", "overwriteFiles": true, "sequentialFilenames": false, "saveToRepository": true, "usingDefaultReportOutputFolderURI": false, }, "mailNotification": { "bccAddresses": { "address": [] }, "ccAddresses": { "address": [] }, "toAddresses": { "address": [ "rodrigo@xxxxxx.com" ] }, "includingStackTraceWhenJobFails": true, "messageText": "", "resultSendType": "SEND_ATTACHMENT", "skipEmptyReports": false, "skipNotificationWhenJobFails": false, "subject": "Customers Report JSON" }, "alert": { "version": -1, "recipient": "OWNER_AND_ADMIN", "jobState": "ALL", "messageText": "successNOTI", "messageTextWhenJobFails": "failureNOTI", "subject": "statusSUBJECT", "includingStackTrace": true, "includingReportJobInfo": true, "toAddresses": { "address": [ "rodrigo@xxxxxx.com" ] } } } Any ideas?

Hi all, I am in the middle of a timezone drama here and would appreciate any suuggestions on the matter. My problem is the following: I have to set up reports on a jasperserver on which people from different timezones will be running such reports. Reports are made in Jaspersoft Studio and server is in UTC time. When I log in with UTC time all goes fine, but when loged in with PST timezone, parameters on report don't behave as expected, eg: when a date is selected and printed on report, it shows a time difference, not 12:00 AM whch is what it usually shows when selecting a date. This time difference of course can couse to show even another day. What I need is that parameter on report behaves according login timezone not server timezone. Any Ideas? Edit: I just noticed a question here which seems to be my same problem but unfortunatley got no answer. https://community.jaspersoft.com/questions/822951/timezone-input-control-and-reports

Hi All, I am currently on the path to try and build some kind of tool for aiding report creation process. The idea is that I have to do reporting in my company and always using same product (big one) so there are some fields (eg: client_id , price, date, etc) which must always have same format, meaning same pattern formatting wether is a number, currency or date, and same text field dimension, etc. I was looking to use some xml generating library and make it so I can generate my own jrxml files on user input, always using default configuration for same field, so standards prevail easily. Has anyone ever thought about something like this? Or maybe there is another way I am not seeing for achieving my goal. Any Input is highly appreciated. Regards, Rodrigo

@hozawa I saw what you did there, doesn't filter by criteria but i totally got what you are trying to do. I will try that on monday... Thanks a lot !!

Hi all, I am writing reports right now with Jaspersoft Studio and have the following issue: I need to do a Summary at the bottom of report which shall include FIRST and LAST row's specific field, but only when that row meets specific criteria. This is what i've done so far: My variable $V{OPENING_CASH} should bring the opening balance amount of the first row which has "Bonus" as account_type, I've set the expression to the following: $F{account_type}.equals("Bonus") ? $F{opening_balance} : null , but this brings null if condition is not met in first row(as expected lol) what I need is to bring the first row which is not actually null, but I don't know how to actually do this. Any ideas? Thanks in advance