Report _ implement HTML Tag using PLSQL (case study)

2014-05-31 BaoXinjian In Capgemini

I. Summary

The character mode Report developed by Oracle Report Builder becomes a system Report.

• Advantages
  • Graphical development is adopted, which is intuitive
  • Powerful Wizard available
  • Do not use too much code to implement reports in complex formats.
  • The final result is displayed as an independent file, which is easier to pass.
• Disadvantages
  • It is difficult to convert it into an Excel file
  • Although there is a layout editor, the drag of its width and position is cumbersome in actual writing process.

Generate HTML files directly in the database to form an HMTL report.

• Advantages
  • The output file can be saved as execel or word.
  • Simple Layout
  • During debugging, you only need to compile the database and do not upload it to the server like an rdf file.
• Disadvantages
  • There is no visual interface for developing packages
  • A large amount of code is required for reports in complex formats.
  • HTML tags are output, and the generated files are large.

Implementation of HTML reports

• Generate a file by calling fnd_file.put_line on the database.
• During file generation, the file is formatted by dynamically adding html tags.
• Html files can be directly converted to excel or word.

 

Ii. Case studies

Requirement: the customer requires that the supplier information be presented in HTML format.

1. Create Procedure to output HTML tags

2. Create a Program Execuable and set the Program to bxj_html_invoice_report.main.

3. Create a Concurrent Program. The output mode is HTML.

4. Run the program and test http:// I .cnblogs.com/EditPosts.aspx? Opt = 1

Step 1 create Procedure to output HTML tags

1 procedure bxj_html_invoice_report (Errbuf Out Varchar2, Retcode Out Number) is 2 cursor cur_invoice is 3 select pv. VENDOR_NAME, 4 aiv. invoice_num, 5 aiv. invoice_date, 6 aiv. invoice_amount, 7 aiv. invoice_currency_code 8 from Ap_Invoices_All aiv, po. po_vendors pv 9 where rownum <= 100; 10 l_invoice cur_invoice % rowtype; 11 begin12 apps. fnd_File.Put_line (apps. FND_FILE.OUTPUT, ' 

Step2. create Program Execuable and set the Program to bxj_html_invoice_report.main.

 

Step create a Concurrent Program and pay attention to the HTML output mode. Other settings are not much different from common CP.

 

Iii. Case Test

Test1. call the Concurrent Program. The output mode is HTML. view the output.

 

Reference: saiyi consulting http://wenku.baidu.com/link? Url = lDoNquiWPnFoazuRRCtvjjBoFBh9TuuFG_5gXVNXKHunzvDMcp1ZQA19mwcnuCFWengm0eBdV23_F_qzMuaKoCsjZzDN1rBi7ZS4w6OJ-f7

Reference: Wang Zhongdong http://wenku.baidu.com/link? Url = VcQejF0TbWNkYERcGkRZVJOA_NUtaeiziImjTXkmyB0BgSI9IS3lErFhy-1hPoBYbsXf5MfYP1mh0Az83jec7Tm23rxKjQsYE0GiTUpEJmG

 

Thanks and Regards