Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi, you could burst report into a directory with bi Publisher..
-
Depending on how it was uploaded, it may be because of the language/territory that it's not the same ..
-
Well, can you explain a little more what you are using as technology ? it's possible as if you want a logo for instance in the upper left corner. Image can be stored in the database as BLOB, extracted through XML and printed on the rtf report. (Check&PO uses this logic). In the rtf, you can resize the image....example…
-
Hi there, i've done something similar...maybe it could help. 1 - I've created an rtf Template with 35 columns which were very small. columns are 1 char large and the titles are top to down ex : 2 - Under this table, I reference xml field 3 - In the data model definition, I've specified that the default output is Excel So,…
-
Hi, you might look at this example... https://blogs.oracle.com/xmlpublisher/entry/wildcards
-
Hi, seeing your table, it would be possible to sum() column in the XML.. Withing your data structure, you can define an element that will hold the sum result.. take a look at this example. : http://www.quest4apps.com/xml-report-part3/ This way, in your XML data strcuture, sum will be calculated and then, the .rtf will only…
-
Hi , i can't access you file but what i usually do to get total it's : 1a - Declare in a form field a variable Inside the group you want the calculation to occur. --> xx_trans_count : variable in my XML and the sum will be in XX_TOT_XFER <?xdoxslt:set_variable($_XDOCTX,’XX_TOT_XFER', sum(XX_TRANS_COUNT))?> 1b - in another…
-
Hi, you’re right; template will be called on each page if it’s in the footer. The easiest way is probably to have two body/layouts in one rtf to avoid calling problems. So, let say you have an rtf document * On physical page 1 of the word document, structure it this way : a- Header b- Body In this section, place something…
-
Hi, can you put your title in the word header section only. This would print title and parameters on every page and not only the first page. Rectangle with 2 columns could be your body and word will manage it. Remove any unecessay page break.
-
Hi there, we did something for our check logos printing. Since logos are stored in the Databse as BLOB, 1 - we extract them using a function SELECT util_Pkg. Convertblobtoclob64(Fl.File_Data) FROM Fnd_Attached_Docs_Form_Vl Fv WHERE .... 2 - util_Pkg. Convertblobtoclob64 is... .... FOR i IN…
-
Hi, maybe you are facing the usual dilema of doing it really complicated vs developing it so that it's maintanable. - Calculate every level in the Template but it needs more variables as you say - Maybe do different sub-template and depending of the parameter, only call the one user ask. Personnaly in these cases, I…
-
Hi there, Word in managing line printing. Nevertheless, when it comes to total at the end, it becomes a bit tricky. If you want you total always at the same place on different pages, you'll have to use line counter to Limi lines per page. There's a couple of example on the web on how to use line counter. -…