Saturday, February 16, 2013

Report Convert to Excel Sheet RPT2XLS


first of all you should create library
or you should create two packages in Programm Unit
name is
1. RPT2XLS (Package Spec)
2. RPT2XLS (Package Body)
and in each you should describe the row and column and each thing of related to excell.
then you go to LAYOUT MODEL
and create a button name is U_EXCEL1
and type is =  pl/sql
and call 
RPT2XLS.RUN;
Then you define to each field that where you put like
example
------------ --------- Code for Report Header (ABDUL KHALIQUE 08/08/08)--- --------- --------- ---

 RPT2XLS.put_ cell(1, 'GL/Account Code :', FontSize => 8,FontStyle => RPT2XLS.BOLD+ RPT2XLS.ITALIC+ RPT2XLS.UNDERLINE) ;

3 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
    Replies
    1. hELLO , i USED aBOVE 1. RPT2XLS (Package Spec)
      2. RPT2XLS (Package Body)

      i m NOT ABLE TO EXPORT REPORT DATA , ITS EXPORTING ONLY HEADERD..

      Delete
    2. I m not able to export report to excle

      Delete