jeanpierrepolnareff91

Hello everyone, I wanted to list all reports of my jasper server but an unexpected result occured. I have 2 folders with reports : - /L4_logsitics - L4_ESPACE_PUBLIC When I used this API request : http://localhost:8080/jasperserver-pro/rest_v2/resources?resourceType=reportUnit 0 reports from the "L4_ESPACE_PUBLIC" folder were found. However, if I use this API request : http://localhost:8080/jasperserver-pro/rest_v2/resources?q=Listing I can find my Listing report from the "L4_ESPACE_PUBLIC" folder. Is it possible to list all reports of my jasper server with one API request ? Thanks for your help

Hello everyone, I am wondering if anyone here has ever drill across 2 star schemas in jasper ? Sample : 1) FACT_ORDERS_INTEGRATED + DIM_DATE + DIM_PRODUCT + DIM_CUSTOMER + DIM_CHANNEL 2) FACT_ORDERS_SHIPPED + DIM_DATE + DIM_PRODUCT + DIM_CUSTOMER + DIM_CHANNEL + DIM_SHIPPER 3) I want 2 keys measures in one adhoc view : number of orders integrated and number of orders shipped Do you think it is possible ? Thanks for sharing your thoughts Jean pierre

Thanks for the wiki ! I managed to get the resource_name using a subquery inside a join clause, sample here to get report executions (date of exec, report name, report_uri, user exec) : SELECT jia.event_date, jir.resource_name, jia.resource_uri, jia.username FROM jiauditevent jia INNER JOIN ( SELECT DISTINCT rf.uri || '/' || r.name AS resource_uri, r.label AS resource_name, resourcetype FROM jiresource r, jiresourcefolder rf WHERE r.parent_folder=rf.id ) jir ON jia.resource_uri = jir.resource_uri WHERE jir.resourcetype LIKE '%com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.ReportUnit%' ORDER BY jia.event_date DESC Sample result : Event_date Resource_name Resource_uri Username "2022-02-02 17:11:48.745" my report /public/test/my_report jasperadmin

Thanks for your answer yama ! I managed to hide the copy button in a specific theme which I called "no_copy_theme" and I redirect the user to this theme during his login if he have the role "ROLE_USER" and not "ROLE_ADMINISTRATOR" (modified WEB-INF/jasperserver-servlet-pro.xml) : EDIT : I found a method to hide items of the repository menu based on roles (ROLE_ADMINISTRATOR, ROLE_USER, ...) You need to modify the "WEB-INF/jsp/templates/container.jsp" file and replace the content of the subheader to only keep what you need. Here, I have replace the copy button by "nothing" to delete it :

Hello everyone, I want to customize my jasper server interface to hide / disable some buttons in the repository menu. I have already hide some options when I right-click on a ressource (copy and schedule) but I don't know how to hide / disable action buttons on top of the page : /sites/default/files/user_uploads/jeanpierrepolnareff91/jasper_com_question_customize_jasper_ui.png Do you have any idea to solve my problem ? Thanks for your attention, Jean-pierre

Hello everyone, I try to build jasperReports from source, as detailled in the jasperreports-source-build-guide (I have jasper reports 7.5.1) (link) I have successfully exec the "js-ant build-ce" command to build the jaspersever folder, but when I exec "js-ant build-pro", I have a 501 error : 501 HTTPS Required. Use https://repo1.maven.org/maven2/More information at https://links.sonatype.com/central/501-https-required Did someone ever had this type of problem ?

Hello everyone, I have found an interesting medium tutorial to configure a proxy on an apache server (https://medium.com/code-divoire/reverse-proxying-an-angular-cli-spa-with-apache-and-tomcat-437cb8963a70) I have followed this tutorial and updated my jasper configuration : update of tomcat_path/config/server.xml : <Connector port="8080" connectionTimeout="20000" redirectPort="8443" maxThreads="48" minSpareThreads="10" enableLookups="false" acceptCount="10" debug="0" URIEncoding="UTF-8" protocol="HTTP/1.1" hostname="my_custom_domain.tk" proxyName="my_custom_domain.tk" proxyPort="80" scheme="http"> </Connector> update of tomcat_path/webapps/jasperserver-pro/webinf/js.config.properties with my proxy adress : deploy.base.url = "http://my_custom_domain.tk" report.scheduler.web.deployment.uri = "http://my_custom_domain.tk" But when I launch the jasper server and sign in, I have a 401 unauthorized message and my webpage is reloading over and over without interruption. Has someone already ran into that kind of problem before ?

Same problem here, have you find something ?

Hello everyone, I have read a usefull documentation which explains how to create a schedule job available in jasperreports server with a javascript script : https://community.jaspersoft.com/wiki/example-using-javascript-schedule-report-rest When I try to use it inside my angular application, an error is triggered : "access to fetch has been blocked by CORS policy, ... No 'Access-Control-Allow-Origin' header is present on the requested resource" I tried to modify my cors configuration (jasperserver-pro/WEB-INF/web.xml, ~ line 215) but it had no effect : <filter> <filter-name>CorsFilter</filter-name> <filter-class>org.apache.catalina.filters.CorsFilter</filter-class> <init-param> <param-name>cors.allowed.origins</param-name> <param-value>http://fiddle.jshell.net, https://fiddle.jshell.net, http://localhost:4200, https://localhost:4200, https://srvreporting.arnaudjasper2.tk:4200, https://srvreporting.arnaudjasper2.tk:4200/vizjs-view, https://srvreporting.arnaudjasper2.tk:4200/auth</param-value> </init-param> <init-param> <param-name>cors.allowed.methods</param-name> <param-value>GET,POST,HEAD,PUT,OPTIONS,DELETE,PATCH</param-value> </init-param> <init-param> <param-name>cors.allowed.headers</param-name> <param-value>Cache-Control,X-Suppress-Basic,Origin,Accept,X-Requested-With,Content-Type,Pragma,accept-timezone,withCredentials,X-Remote-Domain,X-Is-Visualize,x-jrs-base-url,Content-Disposition,Content-Description</param-value> </init-param> <init-param> <param-name>cors.exposed.headers</param-name> <param-value>Access-Control-Allow-Origin,Access-Control-Allow-Credentials</param-value> </init-param> <init-param> <param-name>cors.support.credentials</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>cors.preflight.maxage</param-name> <!-- param value was 300 --> <param-value>1800</param-value> </init-param> </filter>Do you have some advices ? Thanks in advance for your help. Best Regards, jean-pierre

I finally found something usefull right here https://community.jaspersoft.com/wiki/visualizejs-api-notes-and-samples-report#Hyperlinks

Hello everyone ! I'm currently using visualize.js to build a custom web application and I am using report events to trigger other functions : report = v.report({ ... events: { beforeRender: function (el) { var_A = func_A(): }, reportCompleted: function (status) { if (status == "ready") { var_B = func_B(); } else { var_C = func_C(); } }, }, I found a list off event in this page (https://community.jaspersoft.com/wiki/visualizejs-complete-list-built-events-report-rendering), it's very usefull ! But I don't know if there is a similar list for dashboard and adhoc view events, do you know where I can find it ? Thanks in advance for yor help !

Hello everyone ! I am building a web application using visualize.js and I have already implement report rendering and pagination. I was wondering if it was possible to look for a specific word inside a report (like in jasper server) : Is there someone that already have done this before ? Thanks in advance for your help, Jean-pierre

{ //---------------------------------------------- start java script ------------------------- var param1var = getQueryVariable("singlesingon"); var path_to_report = getQueryVariable("path_to_variable"); var report_name = getQueryVariable("report_name"); if (param1var == 'y') window.location.href = "http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&ParentFolderUri="+path_to_report+"&reportUnit="+path_to_report+"/"+report_name; function getQueryVariable(variable) { var query = window.location.search.substring(1); var vars = query.split("&"); for (var i=0;i<vars.length;i++) { var pair = vars[i].split("="); if (pair[0] == variable) { return pair[1]; } } //alert('Query Variable ' + variable + ' not found'); } //---------------------------------------------- end java script ------------------------- }

Hi Yann, I have JRS 7.5.0 and I have this options in Log settings : I think that debug mode for the "Profile attributes resolver" will be enough. Thanks for your help !

Hello everyone, I have several planified reports for the same hour each day (let's say 10:30) and when an error occurs at 10:30, I don't know how to find the "bugging" one in jasperserver.log Example of log : 2020-09-02T10:24:41,759 ERROR ErrorPageHandlerAction,http-nio-8080-exec-4:118 - Error UID 54a76a2a-c6b4-4e41-bbcd-001867db2df4 com.jaspersoft.jasperserver.api.JSException: Error filling report Is there a method to print the name of the report inside jasperserver.log ? Thanks for your help

Unfortunately, I failed to solve the problem. I just created an Ubuntu VM and it works well for now

You're right, I have this "Error creating bean with name 'keystoreManager' : Invocation of init method failed. I will try to debug my JasperReports using this doc https://community.jaspersoft.com/wiki/encryption-jasperreports-server-75#Updating_Keystore_files, thanks for your help !

Hello everyone, I just configured a basic windows VM with only JaspeReports server installed (version 7.8.0) and when I try to go on the http://localhost:8080/jasperserver-pro page an error occurs : ERROR ContextLoader,localhost-startStop-2:350 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeSource' defined in ServletContext resource [/WEB-INF/applicationContext-themes.xml]: Cannot resolve reference to bean 'themeCache' while setting bean property 'themeCache'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'themeCache' defined in ServletContext ... If somebody has ever dealt with this problem before, it would be nice if you could help me. Thanks in advance

Hello everyone, I have many subreports in my jaspersoft main report and I pass the credentials to access specific SQL datasource in the "connection expression" in the subreport tab : I would like to find an another method to make sure that a user can't read this credentials when they access the report with Jaspersoft studio. Thanks for your help.

Hello everyone, I have built an AdHoc view, and everything was fine, but when I add one of my measure, all the values are erased : Could it be caused by a misconfiguration at the domain level, on this particular measure or something else, I don't know. If someone has already experienced a similar event, can you share the information please ? Best Regards

Hello everyone, I would like that some users could create domains on my JasperReports Server (users with role X), I found a documentation were everything is explaind (doc), it worked in a demo enterprise version of JasperReports but when I tried the same process on the production JasperReports (LDAP configured), I got this error : Error creating bean with name 'remoteServiceConfiguration' -> Error creating bean with name 'authenticationAuthoirizationFilterChainProxy' -> Cannot resolve reference to bean 'filterInvocationInterceptor' while setting constructor argument with key [6] -> java.lang.IllegalArgumentException: Unsupported configuration attributes: [L4_IT_DEVS] (my role) Screen : Has someone already had this kind of error when configuring domain creation for users ? Thanks for help !

Hello ! Thanks for your Wiki page, it's very usefull. I tried your configuration on a demo JasperReports solution and everythink worked well, but when my system administrator followed the documentation on the production server, an error was triggered : Error creating bean with name 'filterInvocationInterceptor' defined in ServletContext resource [/WEB-INF/applicationContext-security-web.xml]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Unsupported configuration attributes: [ROLE_DATASOURCE]It's strange because the applicationContext-security-web.xml wasn't modified during the configuration. Do you have an idea about what can create an error like this ?

Hello everyone, I tried to use an updated variable, returned by my subreport 1 (a total) inside my subreport 2. But my variable has only the default value, not the updated value from subreport 1. Is it possible to pass an updated value to a subreport, or it will always take the default value ? I will add some screenshot soon to explain better. Thanks for helping !

Hello everyone, I had a problem when following the solution of shainaztamboli, when I wanted to display the returned value of my subreport into my main report, the value displayed was null (but the variable weren't null in my subreport). I managed to find a strange solution : Delete resetType = "None" from my main report JRXML file : BEFORE : <variable name="returnValue1" class="java.lang.Integer" resetType="None"/> AFTER : <variable name="returnValue1" class="java.lang.Integer"/> Best regards.

Hello everyone, I have found an intersting tutorial on EsProc, and in this tutorial I need to put jars and a folder with a config file inside the "classpath" of IReport (image) : /sites/default/files/user_uploads/jeanpierrepolnareff91/ireport.png I think that in Jaspersoft, it is equivalent to this menu (Projet -> properties -> Java build Path) : /sites/default/files/user_uploads/jeanpierrepolnareff91/jaspersoft.png Am I right in your opinion ? Thanks for helping !