Monday 29 July 2013

Display Concurrent Program Output In EXCEL Without Using XMLPublisher


Below is the workaround I followed.

1. Add one record to Lookup Type 'CP_OUTPUT_FILE_TYPE' :
1.1) Navigation Path : (Responsibility) Application Developer
> (Menu) Application
> (SubMenu) Lookups
> (Function) Application Object Library.
1.2) Query out Type 'CP_OUTPUT_FILE_TYPE'.
1.3) Add the record:
Code: TEST,
Meaning: TEST,
Description: Test of Excel Output.
1.4)Save

2. Match the newly defined concurrent program output file type 'TEST' to Mime Type 'application/vnd.ms-excel' :
2.1) NavigationPath : (Responsibility) System Administrator
> (Menu) Install
> (Function) Viewer Options.
2.2) Add a record:
File Format : TEST,
 Mime Type : application/vnd.ms-excel,
Description : Test Excel Format.
2.3) Save.

3. Check whether Output Format Type 'TEST' is added to concurrent program definition form :
3.1) Navigation Path : (Responsibility) System Administrator
> (Menu) Concurrent
> (SubMenu) Program
> (Function) Define.
3.2) Make sure there is the newly created option 'TEST' in 'Format' field of 'Output' block.

4. Submit one concurrent report with output format 'TEST', make sure it is opened via MS Excel in Client PC when clicking button 'View Output' in Standard Request Submission Form.

2 comments:

  1. Do I need to make any changes in the rdf file as well for the output to appear correctly in excel format .

    ReplyDelete
  2. We cannot add one more lookup to the exisiting one which are setup at SYSTEM level.

    ReplyDelete