Hi,
I have been reading up about reporting solutions other than BI Publisher (due to cost) and would like to have a play with Jasper Reports on my Oracle Workspace (my environment in https://apex.oracle.com/en/).
I have installed Jaspersoft iReport Designer 5.5.1 and am trying to connect it through a JDBC connection (not sure if I should be using a different connection) and tried to following the steps in the presentation on Opal-Consulting - Free tools - Jasper Reports Integration
Can someone tell me the values that I have to enter into the following fields:
JDBC Driver: Defaulted as PostgreSQL (org.postgresql.Driver)
JDBC URL: Defauled as jdbc:postgresql://localhost:5432/DatabaseName
The workspace is obviously currently in apex v5 but the environment that I will enventually want it to work with is v4.2
PS - I have tried adding PL-jrxml2pdf to my workspace but it fails (supporting objects do not get installed). Tried to install it in 4.2 (our production environment) and it and the supporting objects were created OK.
Thanks in advance
Chris