iggythedog91

Hello guys, I have to MSSQL databases and I want to use query A or query B to select the good one. I used a parameter in the query : Select orderDate, totalSales FROM $P{Database} And I ran into this error : the variable of type "@P0" must be declared Do you have any clue in order to solve this error ?

Hello jasper community ! I want to use my domain inside jaspersoft studio but I have a problem : when I want to preview my report, I have a "Access is denied" error although I have read permissions on the Domain datasource. Did someone have had a similar trouble and knows how to get out of it ? Thanks in advance !

Hello guys ! I have a report with 3 subreports (no footer inside) and one footer. When I display it in jasper server, I can only show the footer in the first page. Is there a method to print my footer on all the pages, or is it impossible when using multiple subreports ? -> Thanks for help !

Hi man ! I can't do it too, I think that it's not currently possible :(

Hi Arnaud, it seems to work thanks for sharing !

Hello everybody ! I tried JMeter yesterday and it was pretty cool ! I had some performance indicators on my report executions, always usefull. Now I was wondering if it was possible to use JMeter on REST API calls, I don't know how I can do it. Thanks for helping !

Hello everyone ! I would like to know if it was possible to have a restrict Date input control, for example if I have two params (start_date and end_date), how can I fogive a user to set an end date earlier than the start date. Is it possible to do so ?

Hello everyone, I was wondering if it was possible to force the update of several report when I update one of them (update master -> update slave1, slave2 and slave3) and if it was a good practise. Thanks in advance for your help.

Hello everyone, I followed a jaspersoft tutorial to create a TIBCO map (youtube video : (website with ressources : https://community.jaspersoft.com/wiki/how-generate-map-data-postgis-or-shapefiles-use-reports) and when I want to preview the map, this error message appears : "Byte data not found at: https://maps.google.com/maps/api/staticmap?center=37.0,0.0&size=560x360&zoom=8&sensor=false" When I replace "staticmap" by "js", I have data in my browser. (as mentioned here https://community.jaspersoft.com/jasperreports-server/issues/9886) So I was wondering if it was possible to change the URL used by the TIBCO map element or if there was an another way to render TIBCO maps. Best regards.

Finally I tried with the format YYYY-MM-DD as you mentionned danoldenkamp and it worked directly in the URL ! (&date_debut=2018-06-01) Thanks for your help !

Hello everyone ! I have a report with dates parameters (java.util.date) and I can't pass them as arguments by URL. When I searched for a solution, I found that some people made it by passing dates with this format "yyyyMMddHHmmss", but when I try to do so, I haven't got the good date : /sites/default/files/user_uploads/iggythedog91/2019-10-24_14h32_54.png -> Is there a way to pass a Date parameter by URL ? (not with a string parameter converted to a date inside the query) Thanks in advance for your time !

Hello everyone, When we need to configure Active Directory, is it necessary to create roles in the JasperReports Server beforehand or are they automaticelly mapped / created after the connection? Thanks in advance for your help !

Hi everyone, I have created a report template and it works fine, but I wonder if it is possible to have a default datasource / query at the creation of the report. /sites/default/files/user_uploads/iggythedog91/2019-10-22_11h46_03.png -> /sites/default/files/user_uploads/iggythedog91/2019-10-22_11h46_32.png Is it possible to do so in your opinion ? Thanks in advance for your answers !

Hello everyone ! I don't know if it's normal but when I want to use a chart customizer for a barchart, several options are displayed : /sites/default/files/user_uploads/iggythedog91/2019-10-03_14h53_07.png But when I want to do the same thing for a piechart, I can only use "User defined customizer" : /sites/default/files/user_uploads/iggythedog91/2019-10-03_14h52_39.png Is it possible to have several options of chart customizers for a piechart ?

Thanks again arnaudsimon091, it worked !