Jump to content
Changes to the Jaspersoft community edition download ×


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

jeanpierrepolnareff91's Achievements

  1. 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
  2. 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
  3. 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
  4. 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 :
  5. 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
  6. 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 ?
  7. 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 ?
  8. 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
  9. I finally found something usefull right here https://community.jaspersoft.com/wiki/visualizejs-api-notes-and-samples-report#Hyperlinks
  10. 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 !
  11. 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
  12. { //---------------------------------------------- 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 ------------------------- }
  13. 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 !
  14. 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
  • Create New...