Activity for PL-jrxml2pdf
-
chandrakant
posted
a comment
on
discussion General Discussion
Hi We have created report outlining the fields using round rectangle, in preview in jasper it show correctly using jrxml to pdf, the round rectangle becomes square. id there work around for this. Thanks Chandra
-
Muhammad Ahsan Munawar
posted
a comment
on
discussion General Discussion
Hey Andreas, can you give an example i have multiple records i'm using page break to limit the records per page i'm using this expression in the page break: $V{REPORT_COUNT}.intValue() % 6 == 0 should i give this expression in the another detail band or something, can you please clearify or give an example. Thank you.
-
Muhammad Ahsan Munawar
posted
a comment
on
discussion General Discussion
Hey Andreas, can you give an example i have multiple records i'm using page break to limit the records per page i'm using this expression in the page break: $V{REPORT_COUNT}.intValue() % 6 == 0 should i give this expression in the another detail band or something, can you please clearify or give an example. Thank you.
-
Pina Mauro
posted
a comment
on
discussion General Discussion
Hello everybody, I made a report in JasperStudio with a BarChart In preview it correctly shows 4 columns. Generating the PDF from Oracle, with PK_JRXML2PDF_REPGEN, it shows only the first one. Can you help me? Thanks
-
Ivan
modified
a comment
on
discussion General Discussion
:-)
-
Ivan
posted
a comment
on
discussion General Discussion
Hello again, After few months of using JRXML2PDF I started to get errors: ORA-01427 single row subquery returns more than one row. It's being generated by PK_JRXML2PDF_REPGEN package (lines: 7884, 7971, 9362, 9552). So, nothing changed, tables and data are standard as they were before, what would be the cause of this kind of error, has anybody had this kind of a problem? Any advice on this one? Regards, Ivan!
-
Ariel
posted
a comment
on
discussion General Discussion
Greetings atcnf2005, I would appreciate if you could help me by detailing how you managed to make the changes to find the solution, I do not fully understand. Thanks.
-
himansu behera
posted
a comment
on
discussion General Discussion
Hello, i have designed a report using ireport which contains title, page header, column header, detail and last page footer. when i am running this report in oracle apex 20.1 using jrxml2pdf, last page footer is not showing. Can anyone guide to find the solution here ?
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi Ivan, tanks for sharing this. YOu may also have a look into the documentation in the downloaded zip, there is a chapter about fonts included. Regards, Andreas
-
Ivan
modified
a comment
on
discussion General Discussion
Hello, After a while I managed to solve this problem, now report generating process works fine, this is really great tool and would recommend it to anybody dealing with Apex and Oracle technologies in general. Ok, so, I would like to specify in details my steps since I didn't find it on this forum and in some situations I fond that documentation regarding JRXML2PDF was a little bit confusing to me. First, I downloaded arial font that supports Croatian characters, that is aral 1.ttf file. Then I uploaded...
-
Ivan
modified
a comment
on
discussion General Discussion
Hello, After a while I managed to solve this problem, now report generating process works fine, this is really great tool and would recommend it to anybody dealing with Apex and Oracle technologies in general. Ok, so, I would like to specify in details my steps since I didn't find it on this forum and in some situations I fond that documentation regarding JRXML2PDF was a little bit confusing to me. First, I downloaded arial font that supports Croatian characters, that is aral 1.ttf file. Then I uploaded...
-
Ivan
modified
a comment
on
discussion General Discussion
Hello, After a while I managed to solve this problem, now report generating process works fine, this is really great tool and would recommend it to anybody dealing with Apex and Oracle technologies in general. Ok, so, I would like to specify in details my steps since I didn't find it on this forum and in some situations I fond that documentation regarding JRXML2PDF was a little bit confusing to me. First, I downloaded arial font that supports Croatian characters, that is aral 1.ttf file. Then I uploaded...
-
Ivan
modified
a comment
on
discussion General Discussion
Hello, After a while I managed to solve this problem, now report generating process works fine, this is really great tool and would recommend it to anybody dealing with Apex and Oracle technologies in general. Ok, so, I would like to specify in details my steps since I didn't find it on this forum and in some situations I fond that documentation regarding JRXML2PDF was a little bit confusing to me. First, I downloaded arial font that supports Croatian characters, that is aral 1.ttf file. Then I uploaded...
-
Ivan
posted
a comment
on
discussion General Discussion
Hello, After a while I managed to solve this problem, now report generating process works fine, this is really great tool and would recommend it to anybody dealing with Apex and Oracle technologies in general. Ok, so, I would like to specify in details my steps since I didn't find it on this forum and in some situations I fond that documentation regarding JRXML2PDF was a little bit confusing to me. First, I downloaded arial font that supports Croatian characters, that is aral 1.ttf file. Then I uploaded...
-
Ivan
posted
a comment
on
discussion General Discussion
Hello, I downloaded JRXML2PDF instalation and it works fine with Apex, but I'm having difficulties showing few Croatian letters: Čč Ćć Đđ. I was trying different encodings, different fonts, but neither worked. When I create report in Jasper and try to preview it, it all looks ok, but when I put that xml into JRXML_REPORT_DEFINITIONS and run report generating procedure, pdf that I get lacks all those letters. Further more, my JRXML_FONTS table is empty, and according to specifications in that case...
-
Laurent
posted
a comment
on
discussion General Discussion
@Andreas: With my test (the above PL/SQL block, and the provided templates - but it can be done with the original "orders"/"order items" templates), I came out that the issue seems to be related with the construction of de details part of the report. If in the package body of PK_JRXML2PDF_REPGEN.pls, inside FUNCTION FK_RENDER_SUBREPORT, you comment out PR_PUSH_SUBREPORT_DATA(rReport); and all the code below except for RETURn rArea;, the header of the report is generated in PDF format. So, the problem...
-
Laurent
posted
a comment
on
discussion General Discussion
Hi, AS I posted previously, in package AS_PDF3_MOD.pls (version 1.3.1.1 - that can be downloaded from here), that piece of code in function adler32 is: step_size := trunc( 16383 / dbms_lob.getchunksize( p_src ) ) * dbms_lob.getchunksize( p_src ); -- AW Bugfix for Chunksizes > 16383 if step_size=0 then step_size:=16383; end if; In the refered post, that piece of code is: step_size := trunc( 16383 / dbms_lob.getchunksize( p_src ) ) * dbms_lob.getchunksize( p_src ); if step_size = 0 then step_size :=...
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Well, he even pasted the differences I am posting the patched package and package body here. The only change is in function adler32. old code: step_size := trunc( 16383 / dbms_lob.getchunksize( p_src ) ) * dbms_lob.getchunksize( p_src ); new code: step_size := trunc( 16383 / dbms_lob.getchunksize( p_src ) ) * dbms_lob.getchunksize( p_src ); if step_size = 0 then step_size := 16383; end if;
-
Laurent
posted
a comment
on
discussion General Discussion
Templates used for the test
-
Laurent
posted
a comment
on
discussion General Discussion
Hello Andrea, Thanks for your fast reaction. I would like first to summarize the test case (that I also posted on Source Forge - except for the templates). I use for instance the following code to get the PDF as BLOB either from the "city_maps" template or the "orders" template (jrd_id=48,49; select * from JRXML_REPORT_DEFINITIONS where jrd_name like '%order%'; header -> orders, details -> order_items). Both of these templates can be found in the original jrxml2pdf-1.3.1.1.release. I just modified...
-
Laurent
posted
a comment
on
discussion General Discussion
I using jrxml2pdf-1.3.1.1.release, that's the version that can be download from this site. It is a nice and flexible tool to generate PDF documents. I use for instance the following code to get the PDF as BLOB either from the "city_maps" template or the "orders" template. Here is the piece of code I used for the test: set serveroutput on declare i_vcname varchar2(200); v_blob blob := empty_blob; v_length number := null; -- v_name jrxml_report_definitions.jrd_name%type := 'city_maps'; v_name jrxml_report_definitions.jrd_name%type...
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, there is a workaround decribed here https://sourceforge.net/p/pljrxml2pdf/discussion/general/thread/fa0e9f1f75/ Unfortunately i have currently no time to provide a new packaed version Andreas
-
Laurent
posted
a comment
on
discussion General Discussion
Hi, Using the same piece of PL/SQL code to generate PDF as BLOB, I get the BLOB (PDF) from Oracle DBMS 12c, but it gets "stuck" with an Oracle RDBMS 19c container database. Does someone know if PL-jrxml2pdf is compliant with Oracle RDBMS 19c? I can eventually provide the steps to reproduce the issue. Thanks by advance for sharing your experience. Kind Regards
-
Mathias Maciel
modified
a comment
on
discussion General Discussion
Hi, I get noticed when I try to generate pdf on APEX and there isn't at least a value greater than zero in "value expression" used on chart the PR_RENDER_AXIS procedure fails with ORA-01476 error message. I attached example to show how it looks when I've at leat one value greater than zero . Is there any suggestion to fix this? Thanks in advance, Mathias
-
Mathias Maciel
posted
a comment
on
discussion General Discussion
Hi, I get noticed when I try to generate pdf on APEX and there isn't at least a value greater than zero in "value expression" used on chart the PR_RENDER_AXIS procedure fails withi ORA-01476 error message. I attached example to show how it looks when I've at leat one value greater than zero . Is there any suggestion to fix this? Thanks in advance, Mathias
-
Pablo Javier Beltrán
posted
a comment
on
discussion General Discussion
Hi, I have the same problem, do you have the solution? regards
-
Eduardo
posted
a comment
on
discussion General Discussion
Una pregunta: Y si Necesito mas de una imagen Fija, como hago referencia a esas imagenes desde la tabla JRXML_REPORT_IMAGES
-
DAVID MALIZIA
posted
a comment
on
discussion General Discussion
I am posting the patched package and package body here. The only change is in function adler32. old code: step_size := trunc( 16383 / dbms_lob.getchunksize( p_src ) ) * dbms_lob.getchunksize( p_src ); new code: step_size := trunc( 16383 / dbms_lob.getchunksize( p_src ) ) * dbms_lob.getchunksize( p_src ); if step_size = 0 then step_size := 16383; end if; The problem in Autonomous ATP is that dbms_lob.getchunksize() can return a number greater or equal to 16383 hence the step size goes to 0. To solve...
-
Daxesh Laiwala
posted
a comment
on
discussion General Discussion
Can you send that patch to me? On Wed, 6 Jan, 2021, 20:13 DAVID MALIZIA, dmalizia@users.sourceforge.net wrote: Hi, I have had to patch as_pdf3_mod to get it to work on 20.2 on Autonomous Database (ATP), and while doing so updated the apex application. Haven't got a clue though how I could contribute this stuff here. Is it working with Apex 20.2 https://sourceforge.net/p/pljrxml2pdf/discussion/general/thread/fa0e9f1f75/?limit=25#2a2f Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/pljrxml2pdf/discussion/general/...
-
DAVID MALIZIA
posted
a comment
on
discussion General Discussion
Hi, I have had to patch as_pdf3_mod to get it to work on 20.2 on Autonomous Database (ATP), and while doing so updated the apex application. Haven't got a clue though how I could contribute this stuff here.
-
Luis Ricardo Oliveira
posted
a comment
on
discussion General Discussion
I'm running in oracle cloud database classic and in autonomous db with both apex 20.2. It works fine.
-
HelmutH. posted a comment on discussion General Discussion
Partially. I moved one of my applications to Apex @ OracleCloud (the Free one, which is 20.2) and it works, the only problem I found was that with some browsers I cannot download the PDF. Probably something changed with the owa utility (?) , not sure ... H.
-
Daxesh Laiwala
posted
a comment
on
discussion General Discussion
I try to to install and run in Oracle Apex 20.2 but it is not working can you work with Apex 20.2
-
Jozef Wozniak
modified
a comment
on
discussion General Discussion
and pdf
-
Jozef Wozniak
posted
a comment
on
discussion General Discussion
and pdf
-
Jozef Wozniak
posted
a comment
on
discussion General Discussion
Hi I have a problem with crosstab report in APEX. There was an error: no data found. I made the fixes in package PK_JRXML2PDF_LOADER: ROWGROUP XMLTYPE PATH '/rowGroup', COLGROUP XMLTYPE PATH '/columnGroup', MEASURE XMLTYPE PATH '/measure', CELL XMLTYPE PATH '/crosstabCell', HEADERCELL XMLTYPE PATH '/crosstabHeaderCell' And the report opens, but it is deformed. Could you remedy? Regards
-
Pavlov
posted
a comment
on
discussion General Discussion
Hello Maciej, I use the 19c too, ans YES, this is the solution! Thank you very much! Regards, Leonid
-
Maciej Myrcha
posted
a comment
on
discussion General Discussion
Hallo Pavlov, what DB version do you use? In my case it is 19, and I found a solution in one of another threads. In AS_PDF_MOD package there is a function pdf_string, I changed following piece of code: dbms_lob.copy( t_rv , t_rv , dbms_lob.lobmaxsize , t_ind + 1 , t_ind ); dbms_lob.copy( t_rv , utl_raw.cast_to_raw( '\' ) , 1 , t_ind , 1 ); to this: lob_max:=dbms_lob.getlength(t_rv) - t_ind + 1 ; dbms_lob.copy( t_rv , t_rv , lob_max , t_ind + 1 , t_ind ); dbms_lob.copy( t_rv , utl_raw.cast_to_raw(...
-
Pavlov
posted
a comment
on
discussion General Discussion
I have the same problem. Characters like "(", ")", "[", "]" are the problem. Andreas, I hope you will find the solution.
-
Maciej Myrcha
modified
a comment
on
discussion General Discussion
Hi, I have following problem: in my report I've created a frame with 3 subreports in it (like in attachment). Top subreport is fixed relative to top, another two are float. My goal is that the frame is not stretched, even when the subreport would stretch beyond the frame - in this case, the subreport should be 'cut' somehow. Is it possible? That would be my main problem. And althought subreports are float, they are rendered one over another :( Another one, connected to frames, is when I put subreport...
-
Maciej Myrcha
posted
a comment
on
discussion General Discussion
Hi, I have following problem: in my report I've created a frame with 3 subreports in it (like in attachment). Top subreport is fixed relative to top, another two are float. My goal is that the frame is not stretched, even when the subreport would stretch beyond the frame - in this case, the subreport should be 'cut' somehow. Is it possible? That would be my main problem. Another one, connected to frames, is when I put subreport in a frame, it is stretched correctly but only in iReport - when I run...
-
Maciej Myrcha
posted
a comment
on
discussion General Discussion
Hallo Andreas, sorry for late answer - I managed to make a workaround in this particular case but came along again to this problem and must ask you for help. I just made a simple jrxml based on select 'Text with brackets ()' text from dual I found that it doesn't matter if both brackets are in the text, or only one of them, in all cases the reports generation hangs up without any error and I become and infinite loop. best regards Maciej
-
Eslam
posted
a comment
on
discussion General Discussion
Thanks for reply Andreas. Is there any intention to handle it soon? If not, is it a matter of specifying the path of fonts on the OS or is it more complex than that? Maybe someone could implement it if you just give us a hint.
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, PL-jrxml2pdf still does not support arabic characters
-
Eslam
posted
a comment
on
discussion General Discussion
Hi Andreas, have you implemented a solution for this problem, yet?
-
atcnf2005
modified
a comment
on
discussion General Discussion
You are the genius, both solutions work, thank you so much, Andy. changes inside function pdf_string( p_txt in blob ) ---first one : use sperate DEST_LOB dest_lob := t_rv;------line added by me dbms_lob.copy( dest_LOB , t_rv , dbms_lob.lobmaxsize , t_ind + 1 , t_ind ); dbms_lob.copy( t_rv , utl_raw.cast_to_raw( '\' ) , 1 , t_ind , 1 ); t_rv := dest_lob; ----line added by me end loop; ---2nd solution , use lob maxsize ,even simpler lob_max:=dbms_lob.getlength(t_rv) - t_ind + 1 ; dbms_lob.copy( t_rv...
-
atcnf2005
modified
a comment
on
discussion General Discussion
You are the genius, both solutions work, thank you so much. changes inside function pdf_string( p_txt in blob ) ---first one : use sperate DEST_LOB dest_lob := t_rv;------line added by me dbms_lob.copy( dest_LOB , t_rv , dbms_lob.lobmaxsize , t_ind + 1 , t_ind ); dbms_lob.copy( t_rv , utl_raw.cast_to_raw( '\' ) , 1 , t_ind , 1 ); t_rv := dest_lob; ----line added by me end loop; ---2nd solution , use lob maxsize ,even simpler lob_max:=dbms_lob.getlength(t_rv) - t_ind + 1 ; dbms_lob.copy( t_rv , t_rv...
-
atcnf2005
modified
a comment
on
discussion General Discussion
You are the genius, both solutions work, thank you so much. insdie function pdf_string( p_txt in blob ) ---first one : use sperate DEST_LOB dest_lob := t_rv;------line added by me dbms_lob.copy( dest_LOB , t_rv , dbms_lob.lobmaxsize , t_ind + 1 , t_ind ); dbms_lob.copy( t_rv , utl_raw.cast_to_raw( '\' ) , 1 , t_ind , 1 ); t_rv := dest_lob; ----line added by me end loop; ---2nd solution , use lob_maxsize ,even simpler lob_max:=dbms_lob.getlength(t_rv) - t_ind + 1 ; dbms_lob.copy( t_rv , t_rv , LOB_MAX----------line...
-
atcnf2005
posted
a comment
on
discussion General Discussion
You are the genius, both solutions work, thank you so much. insdie function pdf_string( p_txt in blob ) ---first one : use sperate DEST_LOB dest_lob := t_rv;------line added by me dbms_lob.copy( dest_LOB , t_rv , dbms_lob.lobmaxsize , t_ind + 1 , t_ind ); dbms_lob.copy( t_rv , utl_raw.cast_to_raw( '\' ) , 1 , t_ind , 1 ); t_rv := dest_lob; ----line added by me end loop; ---2nd solution , use lob_maxsize ,even simpler lob_max:=dbms_lob.getlength(t_rv) - t_ind + 1 ; dbms_lob.copy( dest_LOB , t_rv ,...
-
Andy
posted
a comment
on
discussion General Discussion
I have two work arounds for this in the pdf_string function: 1. Don't use dbms_lob.maxsize, but instead calculate the length to be copied e.g. dbms_lob.getlength(t_rv) - t_ind + 1 in the first copy 2. Don't use the same lob as the source and destination in the dbms_lob.copy e.g. have a dest_lob := t_rv before the first copy and use that as the destination lob, then have a t_rv := dest_lob after the final copy Not sure why this is only showing up after 12c, but must admit that I can't think any cases...
-
Ricardo Ortín Tomás
posted
a comment
on
discussion General Discussion
en el diseño no debes poner los subreportes en detail, si solo va a indicar esto lo puedes poner en el title o en un group
-
atcnf2005
modified
a comment
on
discussion General Discussion
Hi, All, I have the same "hanging" problem with Oracle DB 19.7(patched over 19.3) /Apex 20.1 even with Mathias's "fixing", I am a programmer yet I don't know what to do next. The strange thing is that it's fine to run the Demo reports like Orders/Order Items. My customized PDF report has been running fine for years under Oracle DB 11.2.4 for our business. Is there any way this library can be upgraded? I know it's open source and we are grateful for Andreas's great contributions. Best Regards
-
atcnf2005
posted
a comment
on
discussion General Discussion
Hi, All, I have the same "hanging" problem with Oracle DB 19.7(patched over 19.3) /Apex 20.1 even with Mathias's "fixing", I am a programmer yet I don't know what to do next. The strange thing is that it's fine to run the Demo reports like Orders/Order Items. My customized PDF report has been running fine for years under Oracle DB 11.2.4 for our business, is there any way this library can be upgraded? I know it's open source and we are grateful for Andreas's great contributions. Best Regards
-
Nikola Smuk
posted
a comment
on
discussion General Discussion
I found solution how to change pdf filename.... In PL/SQL process where you call PDF change this: PK_JRXML2PDF_REPGEN.PR_SHOW_REPORT(bl); to this: PK_JRXML2PDF_REPGEN.PR_SHOW_REPORT(bl, 'inline', vcFilename); You can fill variable vcFilename in process manually or set value from item.
-
Nikola Smuk
posted
a comment
on
discussion General Discussion
I don't now did you found solution, but i did. I'm using APEX 19.2 and this is how i get rid of that error. I have page 200 that have Before Header Process: DECLARE vcName VARCHAR2(200) := 'NSN_NARUDZBA'; lParams PK_JRXML2PDF_REPGEN.TPARAMLIST; bl BLOB; BEGIN lParams(1).vcName := 'ID_NARUDZBA'; lParams(1).vcValue:= :P200_ID_NARUDZBA; lParams(2).vcName := 'ID_TVRTKA'; lParams(2).vcValue:= :P0_ID_TVRTKA; lParams(3).vcName := '$$EXTERNAL_FONT_ARIAL$$'; lParams(3).vcValue:= 'Y'; bl :=PK_JRXML2PDF_REPGEN.FK_RUN(...
-
Cruz Pablo Mendoza Huerta
modified
a comment
on
discussion General Discussion
Hola Al ejecutar mi Reporte con un Subreporte, el archivo PDF está vacío pero en JasperSoft si se ejecuta correctamente En el <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" es el nombre del subinforme JRD_NAME de la tabla JRXML_REPORT_DEFINITIONS Código de proceso de Apex: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST;...
-
Cruz Pablo Mendoza Huerta
posted
a comment
on
discussion General Discussion
Hola Al ejecutar mi informe con un subinforme, el archivo PDF está vacío pero en Jasper si se ejecuta correctamente En el <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" es el nombre del subinforme JRD_NAME de la tabla JRXML_REPORT_DEFINITIONS Código de proceso de Apex: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST;...
-
Cruz Pablo Mendoza Huerta
modified
a comment
on
discussion General Discussion
Hello When executing my report with a subreport the PDF file is empty but in Jasper if it runs correctly In the <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" is the name of the JRD_NAME subreport of the JRXML_REPORT_DEFINITIONS table Apex process code: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST; bl...
-
Cruz Pablo Mendoza Huerta
modified
a comment
on
discussion General Discussion
Hello When executing my report with a subreport the PDF file is empty but in Jasper if it runs correctly In the <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" is the name of the JRD_NAME subreport of the JRXML_REPORT_DEFINITIONS table Apex process code: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST; bl...
-
Cruz Pablo Mendoza Huerta
modified
a comment
on
discussion General Discussion
Hello When executing my report with a subreport the PDF file is empty but in Jasper if it runs correctly In the <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" is the name of the JRD_NAME subreport of the JRXML_REPORT_DEFINITIONS table Apex process code: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST; bl...
-
Cruz Pablo Mendoza Huerta
modified
a comment
on
discussion General Discussion
Hello When executing my report with a subreport the PDF file is empty but in Jasper if it runs correctly In the <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" is the name of the JRD_NAME subreport of the JRXML_REPORT_DEFINITIONS table Apex process code: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST; bl...
-
Cruz Pablo Mendoza Huerta
posted
a comment
on
discussion General Discussion
Hello When executing my report with a subreport the PDF file is empty but in Jasper if it runs correctly In the <subreportexpression> <! [CDATA ["Kardex Mat"]]> </subreportexpression> "Kardex Mat" is the name of the JRD_NAME subreport of the JRXML_REPORT_DEFINITIONS table Apex process code: DECLARE vcName PK_JRXML2PDF_TYPES.tName; vcName2 PK_JRXML2PDF_TYPES.tName; l_ReportList PK_JRXML2PDF_TYPES.tReportNameList; r_Params PK_JRXML2PDF_REPGEN.TPARAMETER; l_Params PK_JRXML2PDF_REPGEN.TPARAMLIST; bl...
-
Nikola Smuk
posted
a comment
on
discussion General Discussion
Hi... i'm using ORacle Cloud Free Tier ATP APEX application and implementing PL-jrxml2pdf. All scripts are installed, app is installed, everything works. Problem is with iReport ( or Studio) when i want to add datasource for my ATP. In SQL Developer i use Oracle Wallet to connect to DB. My question is how to connect to DB with Oracle Wallet with iReport ( or Studio) ?? In datasource you can only enter JDBC URL: jdbc:oracle:thin:@localhost:1521:DatabaseName Username and Password. Thanks.
-
Inderjeet Singh
posted
a comment
on
discussion General Discussion
Hi Andreas, Thanks for your response. You were right, that error was from APEX and for some other reason. However, my report was still not working without any response or error. And, I found the solution in another thread (link given below). Not sure whether it's a Oracle DB 19c bug or PL-jrxml2pdf code needs to be updated. It would be helpful if you can suggest anything on it as the solution suggested in this post seems to be temporary only. https://sourceforge.net/p/pljrxml2pdf/discussion/general/thread/03abc63d13/#b621...
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
This error comes from APEX, not from PL-jrxml2pdf. What is the action / url you call when you get this?
-
Inderjeet Singh
posted
a comment
on
discussion General Discussion
Hi Andreas, Thanks for your response. There's no error code. I have attached the error screenshot here.
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, PL-jrxml2pdf has nothing to do with Apache FOP or APEX in general. It's just a DB-package which produces output in PDF-format. I have no idea where the error you show comes from, but it's not PL-jrxml2pdf. Isn't there any error-code in front of the errormessage? Regards, Andreas
-
Inderjeet Singh
posted
a comment
on
discussion General Discussion
Hi, After upgrding my APEX application to Oracle APEX 19.2 with ORDS 19.4, I am getting following error while trying to run PDF report. Producing PDF resources is no longer supported Upon checking, I found out that Apache FOP based functionality to produce PDF has been removed from Oracle Apex 19.2 (refer https://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/ords-releasenotes-194-5908833.html). Does this means, this package will not work with Oracle APEX 19.2. Kindly Suggest...
-
Inderjeet Singh
posted
a comment
on
discussion General Discussion
Hi, Yes. I moved my static lenghty data into a table in multiple rows and then fetch it from there.
-
Arturo Garcia Perez
posted
a comment
on
discussion General Discussion
Se aplico hasta la actualización 1311, sin embargo me sigue saliendo este error El pdfprocess esta con el siguiente código Declare vcName Varchar2(200); lParams REPOSITORIO_APEX.PK_JRXML2PDF_REPGEN.TPARAMLIST; bl Blob; BEGIN vcName := 'ACTIVOS_TI'; lParams(1).vcName := 'CLAVEEMPLEADO'; lParams(1).vcValue := 'SE440'; bl := REPOSITORIO_APEX.PK_JRXML2PDF_REPGEN.FK_RUN(i_vcName=>vcName,i_lParams=>lParams); REPOSITORIO_APEX.PK_JRXML2PDF_REPGEN.PR_SHOW_REPORT(bl); APEX_APPLICATION.STOP_APEX_ENGINE; EN...
-
Ricardo Ortín Tomás
posted
a comment
on
discussion General Discussion
hello I have to insert a subreport on page footer or column footer. My problem is, in Jaspersoft Studio one solution works ok, if i put the subreport on page footer, its dont appear, only a black space on apex, but on Jaspersoft Studio show perfect. If i put the subreport on column footer, Jaspersoft show this error: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal how i can put this subreport on a footer for my document?? Thanks
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, can you provide a sample-jrxml anlong with a simple inline-select so that i can check? Regards, Andreas
-
Maciej Myrcha
posted
a comment
on
discussion General Discussion
Hi, I am testing PL-jrxml2pdf project and I have observed very strange behaviour. My report is based on very simple query: there is ID, NAME and FAMILYNAME columns from sample table. When a column contains brackets, for example "Smith (president)", the generation of report hangs on this row without any error. This is what I see in LOG table as last entries (desc): | | | | No. of text parts 1 | | | | Alignment vertical/horizontal/nY top/left/153 | | | | Set font to courier-N-10 | | | | Render Text...
-
sasidharan
posted
a comment
on
discussion General Discussion
Team I have an issue while opening the PDF file downloaded as it is not opening 100% by default. Is there any setting needs to be changed? I have set the content disposition as download. Thanks Sasidharan
-
sasidharan
posted
a comment
on
discussion General Discussion
Team Can jrxml2pdf support underling tag now? If not what is the alternate we have? Thanks Sasidharan
-
sasidharan
posted
a comment
on
discussion General Discussion
I have changed the markup to html and its woking now.
-
sasidharan
posted
a comment
on
discussion General Discussion
Team I have selected markup as styled for textbox with the text value as "<style isbold="True">My name is :</style>"+$F{NAME} Its working as expected in iReport by making My Name is: bold. But when i call it using jrxml2pdf in apex, text is not getting bold instead i get <style isbold="True">My Name is:</style>Sasi in PDF Appreciate your help
-
Nehemias Arias
posted
a comment
on
discussion General Discussion
Great! Problem was for the condition AND in the print condition. In Jasper you have to use &&, however, in jrxml2pdf you have to replace that && with AND. It's working great. Thank you.
-
suzy stephanie kemayou
posted
a comment
on
discussion General Discussion
do you find a solution ? have the same issue with all others charts except Pie chart. Thanks
-
lucas
posted
a comment
on
discussion General Discussion
Tenes que verificar el Query del report, puede ser que hay te este trayendo mas de un registro.
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, you can check the actual error when you run the report with debuglevel set to 5 and check the output. My guess is that one of your printWhenCondition doesn't follow the rules defined in the documentation of PL-jrxml2pdf. Regards, Andreas
-
Nehemias Arias
posted
a comment
on
discussion General Discussion
Hi Andreas, I have attached a file with the source. oddly, when I previously pasted here, in my initial post, it didn't paste correctly (maybe because it's kind of large). Please notice in attached zip file that I have three querys (main query and two sub datasets). This report works perfectly in Jaspersoft Studio. With no error from database. See also image inside attached zip file with report at runtime. Thank you!
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, i don't kn ow how you created your report-definition, but i don't see any query inside. Without a query PLjrxml2pdf won't work. Maybe have a look at the example-reports how the query is defined there. Regards, Andreas
-
Nehemias Arias
posted
a comment
on
discussion General Discussion
Hi Andreas, Thank you for your response. I inserted the code directly into the database, however, now when trying to run the report I'm getting a "ORA-06502: PL/SQL: numeric or value error" which I think is related to jrxml2pdf trying to read the report definitions. Any advise? PS: I'll attach file next time for such large code. Thank you.
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, i guess you hit an APEX-restriction which not allows to enter more than 32K of text in a textarea. Use the SQL-Tool of your choice to save the jrxml directly into the database-table JRXML_REPORT_DEFINITIONS. Regards, Andreas
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, don't post that much of xml-code inline. better attach it as file.
-
Nehemias Arias
posted
a comment
on
discussion General Discussion
Following jrxml code, using datasets, is rejected by jrxml2pdf. When I paste this code and click on create a new report definition (or save changes if I paste it into an existing report) the jrxml2pdf report definition screen remove everything that I paste it (stays empty, blank, nothing) and keep asking for a code. If I remove both datasets sections then it accepts the code. CODE I'M PASTING: <jasperreport xmlns="http://jasperreports.sourceforge.net/jasperreports" name="cxp_suplidores" pageheight="842"...
-
Mathias
posted
a comment
on
discussion General Discussion
Hello Peter, no i havn't, i'm sorry. I didn't investigate this any further as my little workaround helped me here. And it is probably not a bug as other calls to dbms_lob.copy work just fine. I don't know. Regards, Mathias
-
Peter Raganitsch
posted
a comment
on
discussion General Discussion
Hi Mathias, do you happen to have a Bug# or any other reference to this bug?
-
Andres Andres Andrade
posted
a comment
on
discussion General Discussion
Saludos! Quisiera saber si alguien puede ayudarme por favor. Aún no encuentro una solución.
-
Andres Andres Andrade
posted
a comment
on
discussion General Discussion
Saludos de antemano agradezco su ayuda! Les comento que tengo dos archivos jrxml en ireport, en uno de ellos está el reporte principal y en otro el subreporte, funcionan con éxito al presionar el botón de PREVIEW. El problema es que cuando estos los implemento en el aplicativo Oracle Apex,se repite el subreporte. Investigué que si agrego el subreporte en la banda de detalle, es esa la razón por la que se repite, entonces lo quité y lo agregué a la banda Footer, pero aún sigo con el mismo problema....
-
Eslam
posted
a comment
on
discussion General Discussion
Execuse me, Andreas. I have the same question. It is not about Apex. I just want to send the report whose design is stored in the database as JRXML directly to the printer. So, if there is a subprogram you've created for that purpose, I can call it through a button in my page. Have you developed any subprograms for that purpose?
-
Witsarut Somaphee
modified
a comment
on
discussion General Discussion
Hi , This is my new issue . I found that the Image tag in Jaspersoft Report cant read parameter this is my script of image tag : <imageexpression><![CDATA[$P{APP_ID}]]></imageexpression> Program read this parameter ($P{APP_ID}) like string not value of it. I dont know how to fix it. Regards, Witsarut
-
Witsarut Somaphee
modified
a comment
on
discussion General Discussion
Hi , This is my new issue . I found that the Image tag in Jaspersoft Report cant read parameter this is my script of image tag : <reportelement uuid="799a7d8f-6c89-4836-8f3e-7724efe6ef69" height="60" width="60" y="25" x="30" stretchtype="RelativeToTallestObject"> <imageexpression><![CDATA[$P{APP_ID}]]></imageexpression> -- Program read this parameter ($P{APP_ID}) like string not value of it. I dont know how to fix it.</reportelement> Regards, Witsarut
-
Witsarut Somaphee
modified
a comment
on
discussion General Discussion
Hi , This is my new issue . I found that the Image tag in Jaspersoft Report cant read parameter this is my script of image tag : " <reportelement uuid="799a7d8f-6c89-4836-8f3e-7724efe6ef69" height="60" width="60" y="25" x="30" stretchtype="RelativeToTallestObject"> <imageexpression><![CDATA[$P{APP_ID}]]></imageexpression> " Program read this parameter ($P{APP_ID}) like string not value of it. I dont know how to fix it.</reportelement> Regards, Witsarut
-
Witsarut Somaphee
modified
a comment
on
discussion General Discussion
Hi , This is my new issue . I found that the Image tag in Jaspersoft Report cant read parameter this is my script of image tag : <reportelement uuid="799a7d8f-6c89-4836-8f3e-7724efe6ef69" height="60" width="60" y="25" x="30" stretchtype="RelativeToTallestObject"> <imageexpression><![CDATA[$P{APP_ID}]]></imageexpression> Program read this parameter ($P{APP_ID}) like string not value of it. I dont know how to fix it.</reportelement> Regards, Witsarut
-
Witsarut Somaphee
modified
a comment
on
discussion General Discussion
Hi , This is my new issue . I found that the Image tag in Jaspersoft Report cant read parameter this is my script of image tag : <reportelement uuid="799a7d8f-6c89-4836-8f3e-7724efe6ef69" height="60" width="60" y="25" x="30" stretchtype="RelativeToTallestObject"> <imageexpression><![CDATA[$P{APP_ID}]]></imageexpression> Program read this parameter ($P{APP_ID}) like string not value of it. I dont know how to fix it.</reportelement> Regards, Witsarut
-
Witsarut Somaphee
posted
a comment
on
discussion General Discussion
Hi , I want to do dynamic image passing parameters by using #APP_IMAGES#APP_ID..png but I dont know how to do it. I try to called image from item that I created and put it into variable like this : item is P123_NEW display image by declare vcPicture := nvarchar(200); begin vcPicture:= :P123_NEW lparams(5).vcName := 'something'; -- name of parameters in xml script <![CDATA[$P{something}]]> lparams(5).vcValue := vcPicture; Sorry, I am not good at English. Thanks for your helps Regards, Witsarut
-
Andreas Weiden
posted
a comment
on
discussion General Discussion
Hi, 1. parameter are passed to PL-jrxml2pdf as VARCHAR2-parameters. So, when you want to query a Date nad pass the parameter as varchar2 in format yyyymmdd, you have to do a TO_DATE(P{param},'yyyymmdd') 2. The column-mode is not supported by PL-jrxml2pdf.
-
Cesar Hunning posted a comment on discussion General Discussion
Hi all My report is producing 2 different errors First in execution because of a date parameter that I use in a TABLE item that relates to the main report query. I've already tried using the parameter as char or date but none works. In the attached image, the point where the error occurs is detailed. I've already used to_char ($ P {p_datrod}, 'yyyymmdd') but it does not work. Without the mask it produces the error ORA-01830, with the mask producing error ORA-01722 If you put trunc (sysdate) to test,...
1 >
Oh no! Some styles failed to load. 😵
Please try reloading this page