Dietmar Aust

daust ·

Using Calibri/customized Fonts in PDF generation

Hi,

I will have a look at it next week.

Best
~Dietmar.

Unable to generate .csv file. PDF and xlsx work fine

Hi @flbessa ,

it will be released in a few days.

In the meantime, you can use the following files, they will be identical to what will be released later:

How to connect with Oracle Cloud database or autonomous database with JasperReportsIntegration

Great @daxlai,

then please mark this thread/question as "solved".

It will help others to quickly figure out what works or not.

Thank you.

Oracle APEX CLOUD

Hi @Darioitaly,

hhhhm, I guess not. I am using UTL_HTTP to call the report, but they only allow APEX_WEB_SERVICE I believe.

Did you ever try it?

Thanks
~Dietmar.

How to connect with Oracle Cloud database or autonomous database with JasperReportsIntegration

@daxlai , @MohamedHeba does it work now for you? If yes, please mark the question as "solved". Thank you.

Unable to generate .csv file. PDF and xlsx work fine

I could reproduce it and have created an issue for that: https://github.com/daust/JasperReportsIntegration/issues/111

And I already fixed it in 2.9.0.

Unable to generate .csv file. PDF and xlsx work fine

Typically, a simple test case is based on USER_OBJECTS or some other data dictionary view because I don't have your data model / tables like fm_erp_interface_ar.

But I can have a look just need to rewrite the query.

Unable to generate .csv file. PDF and xlsx work fine

Hi Filipe,
can you provide a simple test case ... a test.jrxml file?
Thank you.

Tomcat error after updating libraries

Hi Peter,

this is difficult to troubleshoot.

I would recommend to download the latest version and upgrade as per instructions: https://github.com/daust/JasperReportsIntegration/blob/main/src/doc/github/installation-upgrade.md

If you should encounter a...

Direct printing from JRI and Apex

Hi Fayas,

great, that you could figure it out yourself.

Yes, you also have to activate the printing in the application.properties file as well (this is done for obvious security reasons):

#============================================================...

Direct printing from JRI and Apex

Hi Fayas,

please send me a message via email to dietmar.aust@opal-consulting.de, then we can schedule a quick look.

Thanks
~Dietmar.

Report output is blank

Hi Bala,

JRI tries to recompile the .jrxml file into .jasper and hits a compilation problem:

Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/...

Report output is blank

Wonderful, glad it works now.

Keep in mind, when you deploy files (source .jrxml and compiled .jasper file) the timestamps will be checked. If the .jrxml is newer than the .jasper file OR the .jasper files does not exist, the .jrxml will be used and t...

Report output is blank

Don't see any issue.

Please

  • post the url that is generated (without the hostname for security)
  • run the test.jrxml which is included in the distribution
  • post a screenshot of the output
  • post the logfile from rendering the test.jrxml

Thankx

Direct printing from JRI and Apex

Hi @charlyschmid,

with that little information, it is really hard to troubleshoot. Could be so many different issues, even typos.

Typically, the report is sent to the queue ... things can go wrong from there.

In order to troubleshoot, I would

    ...

Direct printing from JRI and Apex

Hi @LSoriana,

please pardon my late response.

Did you figure it out?
If not, please do also post a screenshot of the output from the printer diagnostics.
Also, check the logfile on the Tomcat, i.e. catalina.out, if you can see anything there.

Thank you~Di...

Compatibility with Apex 5.1.1

Hi Tullio,

yes. It will work with pretty much any APEX version because it is "just" a pl/sql API that communicates with the J2EE server running the custom war file jri.war.

There is an APEX test application, though. This application helps you to chec...

error when Calling Multi Data-source from Oracle Apex

bug enhancement help wanted

Hi @msami07,

I designed the integration for a single Oracle db-connection, your use case is not expected.
Can you use database links to your SQL Server database? This is the typical workaround in those cases in the "Oracle world".

FAIL - Application at context path [/JasperReportsIntegration] could not be started

help wanted

Good that you have it working but I don't understand what you have changed and how you are running it.
Anyhow, glad you could fix it.

Best
~Dietmar.

FAIL - Application at context path [/JasperReportsIntegration] could not be started

help wanted

I don't know where you went wrong. But you can use the jetty as is.

I still believe it is a privilege / access issue.