How to call subform form TIBCO Jaspersoft in Joget?

 
1
0
-1

Dear Sirs,
How can I call subform from TIBCO Jaspersoft in my project. I try to run it, I add 'subreport.jasper' file in Resource menu. Then, I call '#appResource.subreport.jasper#' fail, it show 'net.sf.jasperreports.engine.JRException: Error opening input stream from URL: https://offish.cloud.joget.com/jw/web/app/finance/resources/
subreport.jasper.'.  How can I fix this problem.

Best Regards

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Thanks for your help, it can now be fixed by setting up at Resource > set Permission = is anonymous .Then, I call '$P{REPORT_CONNECTION}' fail, it show ' Unauthorized access to jdbc:mysql://jogetdb:3306 '. How can I fix this problem.
      Best Regards

      1. Anders

        From the error message it appears you do not have permission to access the database so you need to check that.

      2. Bastiana

        In your jasperreport menu, you should select "default datasource" so that it will use the same DB as your Joget instance without the worry of needing to set up the connection details manually.

      3. innovative village

        I have selected "default datasource", but it still fails. Is there any other solution?

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi, try checking the logs to see what the actual error is. Is the URL accessible? You can try to check the permission settings for the resource file.

        CommentAdd your comment...