Results 1 to 9 of 9

Thread: BI Publisher - Invoice Print [Auto Fill Page]

  1. #1
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    183

    BI Publisher - Invoice Print [Auto Fill Page]

    I think this is a simple question regarding BI publisher table layout. I am trying to have the table containing invoice details 'fill' the page. I would like to keep the table size the same no matter how many records are contained within the table so if there are 3 records or 20 records the table size does not change...in other words maintain positioning on the output (PDF) report.

    Is there a way to have the table in the BI publisher document (RTF document) auto-size so that it does NOT resize (shrink or grow) according to the number of data records?
    I have attached screen shots of the RTF document and the resulting invoice printout (PDF).

    Let me know if you need additional information as I will provide.

    Thanks in advance!
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.2.2.6, Application RL 9.2
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  2. #2
    Member
    Join Date
    Jan 2010
    Location
    Karnataka
    Posts
    194
    Hi Mike,
    Unfortunately producing a static table in RTF is not that easy. You can do this as stated below.

    In you report maintain a counter which will preset the records on Page 1, Page 2 and like wise. For example, if you decide to set 10 records on a page, then your variable should read 1 for the entire 10 records. 2 for next 10 record and like wise. You can then put the loop in your RTF on that variable.
    Now, You have to put an additional loop to fill the empty space. For ex. If no. of records are 4 then you need 6 empty rows to produce the fixed format.
    So, in this way you can ensure you will have 10 records always on the page.
    Regards,

    Abhishek Chhajer

  3. #3
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    183
    First off... thank you for your reply Abhishek!

    I think I may have found a solution....I just need to test as I modified the Word template to merge the cells together into a single cell with one row. Then I specified that the row is to "Exactly" a specific width.
    It seems to work fine but I need to also test page overflow for invoice with multiple lines!

    I will test then attach my RTF document if successful for future posterity...wish me luck
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.2.2.6, Application RL 9.2
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  4. #4
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    183
    Got it...I think.

    I have to merge the cells into one row and place the repeating [for-each] around the merged row. Then after specifying the row width/height "Exactly" it seemed to work fine after that.

    I also had to indicate the "Allow Rows to Break Across Pages" because otherwise I was always getting a first page that had no records on it. So I am attaching a screen shot of the RTF document in case anybody is interested. You may contact me if need more information (just trying to share wealth of information!).

    I forgot to mention I need no lines between the rows which also made the level of difficulty a bit harder.
    Attached Files Attached Files
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.2.2.6, Application RL 9.2
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  5. #5
    Member
    Join Date
    Jan 2010
    Location
    Karnataka
    Posts
    194
    Nice to know Mike!!
    If you can share the RTF and one sample xml that will be great leaning.
    Regards,

    Abhishek Chhajer

  6. #6
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    183

    Invoice Print Template - Auto Fill of Page

    Invoice template....


    *** Seems like the RTF document is not supported??????
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.2.2.6, Application RL 9.2
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  7. #7
    Member
    Join Date
    Jan 2010
    Location
    Karnataka
    Posts
    194
    Just change the extension and we can reword the same.
    Regards,

    Abhishek Chhajer

  8. #8
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    183

    RTF Document - Word (.doc) Format

    Here is the RTF document in Word format....
    Attached Files Attached Files
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.2.2.6, Application RL 9.2
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  9. #9
    Mike and Abhishek , omg.....y'all my heroes. I am having a similar issue.
    I will try the steps outline here and I hope you help me when I get stuck.
    In my case I need the row lines to separate each record, and to repeat for multiple pages.















    Thank you

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.