[Use condtionnal filter on query to choose a table]

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 ?

[Can't use domain inside jaspersoft studio (Access is denied)]

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 !

[Pagination when multiple subreports]

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 !

[Copy a report with his "saved inputControls"]

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

[Use JMeter on REST API calls ?]

Hi Arnaud, it seems to work thanks for sharing !

[Use JMeter on REST API calls ?]

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 !

[Restrict a Date input control]

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 ? 

[Update several "slaves" report when a "master" report is updated]

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.

 

[Byte data not found for TIBCO maps in Jaspersoft Studio]

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.

[Passing date parameters through URL]

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 !

[Passing date parameters through URL]

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 !

 

[Active Directory Roles automatically mapped in the JasperReports Server ?]

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 !

[Is it possible to create a default query in a report template ?]

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 !

[Menu of chart customizer doesn't display all chart customizers]

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 ?

[Bad excel export in jasperReports server]

Thanks again arnaudsimon091, it worked !

[Bad excel export in jasperReports server]

Hello everyone,

I created a report in jaspersoft and when I exported it in XLS with Jaspersoft studio everything was well rendered : 

/sites/default/files/user_uploads/iggythedog91/2019-09-20_12h38_13.png

After this export, I published it to the JasperReports Server but when I exported in Excel format, many things were missing (my chart, some data of the detail band, my image, ...) :

/sites/default/files/user_uploads/iggythedog91/2019-09-20_12h39_00.png

Is it possible to have a good Excel export with the JasperReports Server ?

Best regards.

[Can't sort my AdHoc view (growing / decreasing)]

Yeah it worked, thanks you !

[Can't sort my AdHoc view (growing / decreasing)]

Hello everybody,

I just started to test the Jaspersoft BI Pro suite and I don't know why but it seems that I can't sort my measure in my AdHoc view : 

Measure sorted (growing) : 

/sites/default/files/user_uploads/iggythedog91/2019-09-20_11h19_42.png

Measure sorted (decreasing) :

/sites/default/files/user_uploads/iggythedog91/2019-09-20_11h21_04.png 

Am I doing something wrong and if so how can I sort my measure in the AdHoc view ?

I can provide more screenshots if necessary, thanks for helping me guys !