OraFAQ Forum: Reports & Discoverer » How to present report in XLS format with proper column headings

Home » Developer & Programmer » Reports & Discoverer » How to present report in XLS format with proper column headings (Report Builder 6i ( On Windows XP))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to present report in XLS format with proper column headings [message #535180]

Mon, 12 December 2011 11:40

Hometown
Messages: 35
Registered: October 2010
Location: India

Member

[MERGED by LF]

Dear All

I have a report and require the output in xls/xlsx (Excel) format. Currently following properties under System Parameters in Report Builder 6i have been made
Desname = The path for e.g: \\C:sz-server\c$\ihelp_working\xls\rpt_sample_report.xls
Desformat = Delimited
Destype = File

The rest parameters has default settings I have not changed any of the rest User parameter.The report comes up in excel format but totally in distorted manner. i.e; All the column names of report are displayed first in vertical format followed by actual rows for the report.
Please refer to the attachment to understand how is it appearing.
The requirement is like this

Code: [Select all] [Show/ hide]

Student ID   Student Name    Fathers Name   Guardian Name
       1         sample1        sample2      sample3
       2         sample4        sample5      sample6

And it is displaying like this

Student ID   Student Name    Fathers Name   Guardian Name 1 sample1 sample2  sample3
Student ID   Student Name    Fathers Name   Guardian Name 2 sample4 sample5  sample6

Note: Please refer to the attachment to understand the requirement better.

Regards

[Updated on: Tue, 13 December 2011 09:38] by Moderator

Report message to a moderator