Activity for Andreas Weiden
-
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
-
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;
-
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
-
Hi, PL-jrxml2pdf still does not support arabic characters
-
This error comes from APEX, not from PL-jrxml2pdf. What is the action / url you call when you get this?
-
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
-
Hi, can you provide a sample-jrxml anlong with a simple inline-select so that i can check? Regards, Andreas
-
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
-
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
-
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
-
Hi, don't post that much of xml-code inline. better attach it as file.
-
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.
-
Hi, i currently have no 19c database around to test this. Is there something special in your own non-working report? Regards, Andreas
-
Hi, the detail-band has nothing to do with the page the data ir rendered in. If you want me to have a closer look, provide an example with table data as is suggested earlier. Regards, Andreas
-
Hi, thanks for the detailed error-description. But your report is far too big for me to test, as i do not have your tables and packages. I need an example which i can run on my system, either with a select from a WITH-clause or with a set of create-table and insert-scripts to create the needed objects. btw. if the report works when you put the table-component in a separate detail-band, why do don't keep that configuration? Regards, Andreas
-
Hi, there is a conditional style in your report named "table 1_TD" which uses a condition is not supported by PL-jrxml2pdf. If you remove that conditional style it should work. If you want rowbanding (which is what the conditional style does), refer to the PL-jrxml2pdf-documentation, there is a workaround to make this work. Regards, Andreas
-
I'm not familiar with APEX 18.x. Somewhere in the page-attributes you can set the page's "mime-type". This must be set to "application/pdf". If so install the sample-APEX-app, the report-generation-page is configured as needed. Regards, Andreas
-
What do you mean with that? In what context? When you run it from APEX? If so, this would be a setting in APEX not in PL-jrxml2pdf. Andreas
-
You're welcome Andreas
-
Hi, how do you call the report in APEX. Is it a self-written app? Is it the app provided with PL-jrxml2pdf? Which version of APEX do you use? What is the code you use to call the report? Regards, Andreas
-
Hi, the problem lies in the call of the detail-report in the group-header of group GROUP_POLJA. Any reason why you don't have that report in the detail-region? Regards, Andreas
-
Can you provide your not working example? Regards, Andreas
-
Rotation "Left" should work. Do you have a sample-report (along with sample data) to reproduce your problem? Regards, Andreas
-
Hi, the first thing you could have done is to lookup what the error means. It mean, roughly said, s that is not enough memory availabe for the database. You should check this with your dba. Regards, Andreas
-
Hi, please don't hijack other peoples threads. Create your own one if you have a question. The name of the image in the table JRXML_REPORT_IMAGES must be written exactly the same way you reference it in your jrxml (be aware oc case-sensitivity. And as stated in this thread, if you installed the demo-application there is an example-report which has an image included. Regards, Andreas
-
Hi, no, PL-jrxml2pdf does not support arabic. The problem is that arabic is an RTL-language and also a phonetic language, where specific characters are shown differenty depending on the position in a word. I tried id once, but i'm not capable of reading the results, so the attempt failed. So, sorry, but there are currently no plans to support arabic. Andreas
-
Hi, sorry, i don't know any. Andreas
-
Hi, the name of this tool is PL-jrxml2PDF because it creates PDF-results. For excel you have to find another tool which create excel-results. Regards, Andreas
-
Yes. Create your iReport-definition and load it into the database. Create a Stored Procedure to run the report like the following (pseudo-code) DECLARE CURSOR cr IS SELECT ORDER_ID FROM ORDERS; i_vcName VARCHAR2(200); i_lParams PK_JRXML2PDF_REPGEN.TPARAMLIST; blData BLOB; BEGIN i_vcName := 'report'; -- Modify the code to initialize the variable i_lParams(1).vcName:='PARAM_NAME'; FOR rec IN cr LOOP lParams(1).vcValue:=TO_CHAR(rec.ORDER_ID); blData:=PK_JRXML2PDF_REPGEN.FK_RUN( i_vcName => i_vcName,...
-
You're welcome. Andreas
-
Hi, there is no official path yet, but here are some hints: You'll find several codepieces like the following: FROM XMLTABLE('/crosstab/*' PASSING i_oCrosstab COLUMNS ROWGROUP XMLTYPE PATH './../rowGroup', COLGROUP XMLTYPE PATH './../columnGroup', MEASURE XMLTYPE PATH './../measure', CELL XMLTYPE PATH './../crosstabCell', HEADERCELL XMLTYPE PATH './../crosstabHeaderCell' ); (see the back-references ./../). These have be changed to relative references FROM XMLTABLE('/crosstab/*' PASSING i_oCrosstab...
-
At the moment this works only for Arial, but you can use any other custom font you want.
-
Thats not quite correct. You have to store your font-file (the ttf-file you "downloaded" and you use in your jrxml-definition) in the table JRXML_FONTS with extacly the same name as you use it in the jrxml-definition (the name is case-sensitive). The parameter $$EXTERNAL_FONT_ARIAL$$ has only to be set when you want to use an external Arialfont, which is not the case for you, as you want to use a different font (and even if you wanted to the the parameter there should not be any spaces in the parametername....
-
Did you follow the instructions in this thread to upload the font?
-
Hi, the property "printWhenGroupChanges" is not supported by PL-jrxml2pdf (see docs for supported tags). Regards, Andreas
-
Hi, sorry but PL-jrxml2pdf does not support arabic or any other RTL-language. Regards, Andreas
-
Hi, i guess the problem are the conditional styles used for the table. Read the documentation, there is a description how alternating row can be implemented using PL-jrxml2pdf. Regards, Andreas
-
Hi, columns are currently not supported. Regards, Andreas
-
Hi, your way is the correct way. Why can't you pass single quotes from Apex. In PL/SQL, use two quotes to have a quote inside a string, like '''a'',''b'',''c''' Regards, Andreas
-
Hi, i found the problem and fixed it in the codebase. As i have currently no time no release a new version, you'll have to correct the error on your on: In the body of package PK_JRXML2PDF_REPGEN check line 3329 and change it from rData.iCount:=rData.iCount+1; to rData.iCount:=NVL(rData.iCount,0)+1; This should fix the problem. Regards, Andreas
-
Hi, i don't havr your tables and data, so i can't help with this definition. If you setup a little test-report, which uses data in a WITH-clause, so that i can run it on my system, i might be able to help you. Regards, Andreas
-
Yes, you cann pass parameters to subreports. In the example-folder there is an example for orders which uses a subreport for the order-lines. About how to pass multiple parameters, how do you pass one parameter? It should be using a params-array. And for two parameters you just pass two entries.
-
Hi Sabuj, PL-jrxml2pdf does only a support some basic expressions, which are all documented in the pdf which comes with the download. The expression you use is not supported. Instead of doing the comparison in an expression, do the same in the query using e.g. CASE 'Absent'=STS THEN 1 ELSE 0 END Regards, Andreas
-
Hi, i'm afraid but there will be no support for arabic in the near future. Andreas
-
Hi, i'm afraid but there be no support for arabic in the near future. Andreas
-
Hi, sorry to say, but arabic is a rtl-language which does the handling of characters completely different to languages like english. PL-jrxml2pdf does currently not support arabic.
-
Hi, sorry, but i have currently no time to fix this. But you can apply a hotfix yourself Check lines 1324 ff in PK_JRXML2PDF_REPGEN, they should be IF lHtmlReplacements.EXISTS(vcTag) THEN vcText:=REPLACE(vcText, vcTag, lHtmlReplacements(vcTag)); ELSIF vcTag LIKE '&#x%' THEN vcText:=REPLACE(vcText, vcTag, '\' || LPAD(TRANSLATE(vcTag, '&#x;',''), 4, '0')); ELSIF vcTag LIKE '&#%' THEN vcText:=REPLACE(vcText, vcTag, '\' || TO_CHAR(TO_NUMBER(TRANSLATE(vcTag, '&#;','')), 'FM000X')); END IF; iPos:=iPos+1;...
-
So, the just insert a row into the table and then use the blob-upload to load the ttf-file into the blob-column. btw. What do you want to achieve by loading the font into the table? Andreas
-
Hi, this looks like the raw-data from your blob is HTML-text, and PL-jrxml2pdf does not automatically translate HTML to a proper layout. There is an example-report in the zip which show how to use a HTML-region in a report. Try it and check if your problem gets solved. Andreas
-
Hi, you should read the documentation there is also a chapter about fonts. What do you mean with "How to insert arial font into .. table? Do you want to know how to create a reocrd in the table? What tool do you use for your database development? Andreas
-
There alle several options for a failure. Is there a reocrd with JRD_ID=1 in JRXML_REPORT_DEFINITIONS? Is there a JRXML-Definition stored in that record? If the report-definition exists, what is the value for P1_Emp? What is your query? If you execute the query manually, do you get any result? Regards, Andreas
-
Hi, this error indicates that the output of the report is empty. This could indicate that your query doesn't return any records. From your code i would guess that you have a Date-parameter, which is passed as a string to PL-JRXML2PDF. Make sure that you use it appropiately in the query, like WHERE DATAFIELD=TO_DATE(:pSalMonth, '<APPROPIATE FORMATMASK>'); to use the correct formatmask, check what the value of :P1_date (which is a VARCHAR2) is and use that format-mask in your query. Regards, Andre...
-
Hi, you could use $F{DS_OBSERVACAO}!=null which will be translated to $F{DS_OBSERVACAO} IS NOT NULL Regards, Andreas
-
Hi Inder, sorry, but this kind of dloating fieldsizes is not supported by PL-jrxml2pdf. If the field is the only field over the whole width of the report, you could put it in an extra detailband, then it would work. Regards, Andreas
-
Hi, this thread should help you. https://sourceforge.net/p/pljrxml2pdf/discussion/general/thread/0d5c1381/ Regards, Andreas
-
Hi Jose, if this would be so easy, the code would have been already added. If the data you want to hide is in the detail band, you can "split" your detail band inti several details bands and add a print-when-expression to the detail-band you want to hide. Regards, Andreas
-
Hallo Gerhard, die Property Scale Image wird von PL-jrxml2pdf nicht unterstützt. Dies liegt einfach daran, dass es in PL/SQL keine Möglichkeit gibt, die Größe eines Images anhand des BLOB's zu erkennen (zumindest nicht mit der XE). Mit einer "größeren" Version könnte man die Image-Größe über das ORDIMAGE-Package ermitteln und dann auch diese Property unterstützen. Eine entspechende DB-Version vorausgesetzt, könntest wäredu das PK_JRXML2PDF_REPGEN-Package entsprechend anpassen, dass du die Image-Größe...
-
Hi Inder, that's enough. You just have to make sure, that the name in your CDATA-section is the same as the name-column in the images-tables (the name is case-sensitive).
-
Hi, sounds like you have a function call in your query and that function returns a value which is too large (maybe a VARCHAR2 longer then 4000 chars). But without seesing the query this is only guessing. Regards, Andreas
-
Hi, the problem is that your subreport doesn't contain any valid query. Regards, Andreas
-
Hi, at the barchart there is a property "Value Axis Tick Label Format". Set this to somethinge like "##0.00" Andreas
-
Hi, sorry for the late reply, i didn't have the time yet to check your problem. Andreas
-
Hi Cameron, yes its possible, but not using the Japser report book. You have to upload all reports separately. Then you can call the function FUNCTION FK_RUN(i_lReports IN PK_JRXML2PDF_TYPES.tReportNameList, i_lParams IN tParamList, i_bResetPageNumber IN BOOLEAN) RETURN BLOB; whichs take a list of report-names. The output of all reports sill be concatenated to one pdf. Regards, Andreas
-
Hi, the problem lies in a changed way the database evaluates XML-queries in 12C. This affects specially the crosstab. I'll try to provide a "patch" for that problem. Regards, Andreas
-
Hi Lucian, i'm sorry but i can't help you with this. I'm not that deep in APEX-development. Regards, Andreas
-
Hi Dirk, merging pdf-files is not possible using PL-jrxml2pdf. This is because i'm not able to parse an existing PDF-document. You talk about images from the application..., can't you capture them as image-files, in this case a "merge" would be quite simple? It is possible to merge PDF-files using some external library, e.g. iText can do you using, but i don't know the licensiong required for this. Regards, Andreas
-
Hi, please don't hijack other peoples thread. Open your own. If you want to hide the whole table based on a condition, but the table in a separate detail-band and add the print-when-condition to the band. Regards, Andreas
-
Hi, i refer to the tables used in the report-query (the jrxml-file)
-
Hi, PL-jrxml2pdf does not currently support the column-property, so there is also no option to output multiple columns. Regards, Andreas
-
You have to grant SELECT on the tables/views used in your jrxml-files to your schema JRXML.
-
Hi, you install PL-JRXML2PDF into any schema you want. In fact i'm doing it the way you describe. Are you facing any problems? Regards, Andreas
-
Hi, no, i didn't try to copy a page as i'm neither an APEX-guru nor do i have an APEX 5.1 environment. This problem is an entire APEX-problem and i can't help you with it. I guess the report runs fine when you pass the parameters hardcoded. Andreas
-
Hi, sorry for the late reply, but i didn't have time to check your issue. I'll come back to you as soon as possible. Andreas
-
Hi, sorry for the late reply, but i didn't have time to check your issue. I'll come back to you as soon as possible. Andreas
-
Hi, you also have to put the subreports in separate rows in the JRXML_REPROT_DEFINITIONS-table with exactle the same name (withour path and extension). Andreas
-
Hi, this sounds like an APEX-problem, not an PL-jrxml2pdf-problem. Andreas
-
Hi, check this thread, there is the same problem described with a solution. https://sourceforge.net/p/pljrxml2pdf/discussion/general/thread/46cfa6b8/ Andreas
-
Hi, i don't find any printWhenExpression in your jrxml-definition. Regards, Andreas
-
The example-report "table_usage_with_column_groups" contains a column which is hidden using the print-when-condition. Maybe you have a look at it. If you want further assistance, attach your jrxml-definition. Regards, Andreas
-
Hi, that's currently not possible with PL-jrxml2pdf. If the formatting for the filed an the header is identical, you can define a textfiels like "Header 1: $F{FIELD1} Header 2: $F(FIELD2}" Hope this helps, Andreas
-
Yes there are examples in the documentation. In fact, its just a call of a PL/SQL-function whichs returns a BLOB. Regards, Andreas
-
It depends how you call PL-jrxml2pdf. If you use APEX, you can return the resulting pdf as download to the user, who then can save it to local disk. (You can test that using the APEX-application delivered with the tool). If you call it from outside using PL/SQL, you can store it either to a db-directory (which in on the server-disk) or in a table and then transfer it from there with the frontend-language you use. Regards, Andreas
-
Hi, the first one will work, the second not. Check the documentation, there is a list of condition which can be evaluated. Regards, Andreas
-
There is no need for any database-directory. PL-jrxml2pdf only looks into the table JRXML_REPORT_DEFINITIONS with the name specified in the subreportExpression. Any path is removed. There is an example report delivered with the zip showing the behavior. Remember that the report-name is case-sensitive. Regards, Andreas
-
Hi, PL-jrxml2pdf does not "understand" such complex java-expressions. I would suggest to do the formatting in the query, you might use something like to_char(THE_DAY, 'FMDy d') Regards, Andreas
-
No news yet. The package used to generate the barcodes/qrcodes is still "under construction", such is the integration in PL-jrxml2pdf.
-
You're welcome.
-
I guess that your setting of the parameters is wrong. Do you have an APEX-collection...
-
Hi Basuki, from the last screenshot i see that reports runs fine when executed from...
-
Hi, this seems to be no PL-jrxml2pdf-problem. At first, there is no usage of JSON...
-
Hi, sorry, this forum is about PL-jrxml2pdf, not about Jasper-reports itself. Regards,...
-
Check ths solution provided in this thread https://sourceforge.net/p/pljrxml2pdf...
-
Image with expressions are supported, check the example-report "images.jrxml" with...
-
Hi, java as a language for defining variable-content is not supported by PL-jrxml2pdf....
-
How many different images do you have?
-
Didn't you say you use a special font for zhe barcode? The use of barcode-component...
-
Hi, currently PL-jrxml2pdf does not support that property. You have to catch that...
-
What is that errorwindow at the bottom? Does that error come when you run your report?...
-
Hi Pedro, but that is only part of the data. There will be more lines in the tables....
1 >
