How to print static text on an XML publisher report — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to print static text on an XML publisher report

Received Response
211
Views
5
Comments

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

  • Amishra
    Amishra Rank 3 - Community Apprentice

    My Test Company                                                                 1. Reporting Mgr 1

    123 Test Rd City, CA, USA                                                    2. Reporting Mgr 2

                                                                                

    CompanyContactCountry
    Alfreds FutterkisteMaria AndersGermany
    Centro comercial MoctezumaFrancisco ChangMexico
    Ernst HandelRoland MendelAustria
    Island TradingHelen BennettUK
    Laughing Bacchus WinecellarsYoshi TannamuriCanada
    Magazzini Alimentari RiunitiGiovanni RovelliItaly

    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

  • Amishra
    Amishra Rank 3 - Community Apprentice

    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.

  • Pavan kumar.
    Pavan kumar. Rank 5 - Community Champion

    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

  • Pavan kumar.
    Pavan kumar. Rank 5 - Community Champion

    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'

  • Amishra
    Amishra Rank 3 - Community Apprentice

    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.