bmservices

Sorry hozawa, field delimiter is not correct. This is the delimiter between the columns. I want to change the decimal separator from "." to ",".

Hi together, is it possible to change the decimal separator in Jasper CSV export? I need decimals formatted like this: 1,2345 instead of 1.2345 Otherwise Excel will misinterpret the CSV after opening with doubl click. Especially f.e. 3.5 becomes 3. Mai! I searched here: http://jasperreports.sourceforge.net/config.reference.html but did not find anything useful here: net.sf.jasperreports.export.csv.* Thx for tips, Bernd PS: xlsx/xls export is not possible... too much data :-(

Thx, that was what I was looking for. Never thought of passing the same parameter multiple times.

Hi, i've got in my jrxml: <parameter name="PROJECT_IDS" class="java.util.ArrayList"> <parameterDescription><![CDATA[Projects]]></parameterDescription> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> Within the Jasper Server GUI I can easily create an element which collects the IDs and passes them correctly to the report. But how do I do this in an URL: GET https://<server>/rest_v2/reports/<reportPath>/<reportName>.<reportFormat>?PROJECT_IDS=... I tried "1,2,3,4" and "[1,2,3,4]" but none of them worked :-( Thx for any hints, Bernd

Hi together, I'm working with REST API on a jasper which was not setup by me. It seems to be configured to work with authentication with bearer token, but not with basic auth. I want to to do a get REQUEST ON: https://<SERVER>/jasperserver/rest_v2/reports/Reports/VK/DF/SP/reporting/AVBAll.pdf Sending a header like "Authorization: Bearer ..." works perfectly fine. Sending a header like "Authorization: Basic " . base64_encode("<user>:<pass>") ends in a 401 error. I'm sure that user and pass are correct. I can login with these credentials into the web interface of the jasper server. Trying to to it via browser: https://<SERVER>/jasperserver/rest_v2/reports/Reports/VK/DF/SP/reporting/AVBAll.pdf => Popup for Crendentials. When I enter the correct ones, the popup comes again. Authentication failed. So it seems that basic authentication is disabled on the jasper server. How can I enable it again? Thanks for tips, Bernd

Thx for the suggestions. Finally I managed it. I changed my data source to the id. So my request body looks like: "label":"mquest_P706_SEG_Rackjobbing", "dataSource" : { "dataSourceReference" : { "uri" : "/Data_Sources/Vertikom_Datawarehouse_PRO" } }, "jrxml" : { "jrxmlFile" : { "type":"jrxml", "label": "mquest_P706_SEG_Rackjobbing", "content" : "..." } } } And I tried to send a PUT request to: https://<server>/jasperserver/rest_v2/resources/Reports/VK/DF/SP/dashboard/export/mquest/mquest_P706_SEG_Rackjobbing?createFolders=true&overwrite=true My error was "ressources" instead of "resources". Then I get 201 created. And the report is working. Regards, Bernd

Hi together, I 'd like to automatically deploy an Jasper-Report on a server after creating a jrxml from a database table. Tested first: manual deployment of jrxml works fine. There is an existing folder on the server: Reports/VK/DF/SP/dashboard/export/mquest So I'm sending a POST request to: https://<server>/jasperserver/rest_v2/ressources/Reports/VK/DF/SP/dashboard/export/mquest with the Headers: Content-Type: application/repository.reportUnit+json Accept: application/json Authorization: Bearer ... In the POST body something like: { "label":"mquest_P706_SEG_Rackjobbing", "dataSource" : { "dataSourceReference" : { "uri" : "/Data Sources/Vertikom Datawarehouse PRO" } }, "jrxml" : { "jrxmlFile" : { "type":"jrxml", "label": "mquest_P706_SEG_Rackjobbing", "content" : "..." } } } In content the base64 encoded jrxml file. I always get a 404 error. Why? Is the URL malformed? Changing Authorization Bearer to something else ends in "unauthorzied". That's ok. Thanks für any help, Bernd

Hi together, what config param must I set in the jrxml file so that the output of the report only is CSV format? Or xlsx format? I don't need a printed report in pdf or whatever format. Searching with "jasper report default output format" did not give me the right hint :-( Thx for help, Bernd