Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to print static text on an XML publisher report
Summary
How to print static text on an XML publisher report
Content
Hello,
I have an XML publisher report that needs to print pre-formatted data. The data itself is stored in a single field within a table. The data looks like this:
Line_num Print_data
--------------------------------------------------------------------------------
1 Test Name 1. Reporting Mgr 1
2 123 Test Ave. 2. Reporting Mgr 2
3 Test City, 123456, Country 3. Reporting Mgr 3
4 Tel: 1234567890
5 <Blank Line>
6 <Blank Line>
7 *** Some Data ***
The requirement is to have this data printed like this:
<Company Logo> Some Heading
Company Address
Print line_num 1 to 5
Column1 Column2 Column3 ... (These headings will replace <blank line> (line num = 6))
Continue to print data from line 7
The company logo, address and column headings (Column1, column2, etc.) need to print on every page. My question is: How do I achieve this? I have to print static data on every page with fixed location and then print the actual data from the table on top of it. Any help is appreciated. Please let me know if you need additional details.
Sincerely,
A
Answers
-
My Test Company 1. Reporting Mgr 1
123 Test Rd City, CA, USA 2. Reporting Mgr 2
Company Contact Country Alfreds Futterkiste Maria Anders Germany Centro comercial Moctezuma Francisco Chang Mexico Ernst Handel Roland Mendel Austria Island Trading Helen Bennett UK Laughing Bacchus Winecellars Yoshi Tannamuri Canada Magazzini Alimentari Riuniti Giovanni Rovelli Italy As you can see, the first 2 lines are coming from one field that contains pre-formatted data in a table. We're printing it as it is. Then I have to print "Company, Contact and Country" as column headings. The pre-formatted data contains blank lines to facilitate this replacement. I then have to continue to print the data from the next line. I can't make these column headings as part of the header as I have to print it in between the lines on each page. Hope this makes more sense. Please let me know if you know a work-around for this issue.
Thanks,
A
0 -
Dear Pavank,
I appreciate the prompt response. However, I've already tried it and it doesn't work for me. It's not the logo that I am concerned about or text at the header. The idea is to be able to print pre-formatted data at fixed locations.
So, to elaborate, if you look at the example I've given in my original post, I have to print first 5 lines on the page, then display column headings to replace line # 6 and then continue to print data from line 7:
Print line num 1-5
Column1 Column2 Column3 ... (These headings will replace <blank line> (line num = 6)
Continue to print data from line 7
I've given an actual expected output as an example below.
0 -
Hi,
If you have fixed logo or signature to print in RTF template, then perform below steps
1) Copy file in .gif format to $OA_MEDIA path at Application Server
2) Insert picture in RTF template and add below text in Web Tab
url:{'${OA_MEDIA}/MAB_NEW.gif'}
and
If you want to print the fixed data in header for each sheet follow the below code
HEADER INFORMATION
<?start:body?>
CONTENT
<?end body?>
FOOTER INFORMATION
0 -
Can you try this....
1. Add @section in for-each tag.
Example: <?for-each@section:G_HEADER?>
2. Enable below check box in Table properties.
'Repeat as header row at the top of each page'
0 -
I appreciate the response Pavank.
I was able to find a workaround using watermarks. I am now printing the column headings in the watermark behind the actual text. The text is now printed on top of the template just like it would on a pre-printed stationary.
0