BI Publisher(rtf)模板开发语法大全(5)

三十一.重复标题行实现(重复表头) Repeatable RowHeaders

If your invoices break across a pageand you want to repeat the column header row, this can be achieved usingMSWord?s functionality. 1. Highlight the header row高亮直接用word设置 2. Table > Table Properties

3. Under the Row tab select the ?Repeat as Header row at the top of each page?

If the invoices table breaks across apage the header row will be repeated.

Splitting Rows acrosspages

You can prevent rows splitting acrossa page break by using MSWord?s functionality:

1. Highlight the data row 2. Table > Table Properties

3. Under the Row tab deselect the ?Allow row to break across pages? Rows that would normally be splitacross two pages are now moved to the second page to preserve the row data. I

在word中设置 举例 IFUse thefor-each@section to repeat the header information across pages of the outputdocument. In this case, the Customer Name will be repeated if the lineinformation runs across more than one page, the page numbering will also bereset.EI for-each@section G_CUSTOMER CUSTOMER_NAME ADDRESS_LINE1 ADDRESS_LINE2 CITY, STATE ZIP DearSir or Madam: for-each G_CURRENCY Your TRX_CURRENCY_CODE defers from the following invoices: Transaction Number Transaction DTransaction AmoTransaction Amoate for-each 01-Jan-2007 unt unt Remaining $ 100.00 $ 100.00 end Transaction Number Transaction DTransaction AmoTransaction Amoate unt unt Remaining for-each G_INVOICESTRX_NUMBER end for-each end for-each 三十二. 页眉页脚logo,时间等 1. There is one caveat to this, you cannot use form fields in the header so you?ll need to use the full placeholder text if you want to use data in the header.

2. It is good practice to use tables in the header and footer area to organize data and objects.

Youcan see in the header and footer of this report that we have several reportobjects embedded:

a) Logos: The Oracle logo is a straightforwardjpg image that has been embedded into the document. XML Publisher also supportsbmp, gif and png. We do not currently support wmf formats. Tip: Try and get alarger image than you need and shrink it in the template, this will improve thequality of the image at runtime.

b) Boilerplate – you can insert any text youwish in the header/footer and it will be repeated on each page (i.e. the reporttitle above, and the company address in the footer).

c) Data – as mentioned above you cannot use formfields in the header/footer area but this does not stop you adding data tothese areas. You just need to use the full placeholder text, this can beformatted just like the form fields and the incoming data will take on the sameproperties.

d) Page numbering – you can insert pagenumbering just as you would in a regular Word document, at runtime XMLPublisher will paginate the output and insert the correct page numbers. Thisuses the word merge fields for page number and total page number so we canbuild up text such as ?Page X of Y? in the template and final output.

e) Run Date – similar to the page numbering wecan also use the date merge field to insert the run date for the report. Itshould be noted that this is the publishing date and not necessarily the datethe data was generated. 注意时间和页数是会自己变化的

创建时 运行时

三十三.数字格式numberformatting

1. XSL natively supports number formatting using its format-number function, it returns a formatted string and takes the form:

stringformat-number(number,format,[decimalformat])

Parameter Description

Number Required. Specifies the number to be formatted

Format Required. Specifies the format pattern. Here are some ofthe characters used in the formatting pattern: ? # (Denotes a digit. Example:####)

? 0 (Denotes leading and followingzeros. Example: 0000.00) ? . (The position of the decimalpoint Example: ###.##) ? , (The group separator forthousands. Example: ###,###.##) ? % (Displays the number as apercentage. Example: ##%)

? ; (Pattern separator. The firstpattern will be used for positive numbers and the second for negative numbers) Decimalformat Optional.

So forexample to format the entered amount for thousands and 2 decimal places wewould use the following in the formfield:

format-number(ENT_AMT, \If you have negativenumbers these are supported too in the format: format-number(ENT_AMT,\denotes how the negative number should be displayed (note thesemi colon separating the formats).So -1234.5 would become (1,234,50)

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库BI Publisher(rtf)模板开发语法大全(5)在线全文阅读。