How can i port this report to an MS-Excel sheet by keeping the same order ? [message #143784] |
Sat, 22 October 2005 08:56 |
nirmalnarayan
Messages: 261 Registered: April 2005 Location: India
|
Senior Member |
|
|
I have a table like below.
Name : EVENT
---------
EVID EVENT
----- ------
1 NEW YEAR DAY
2 CHRISTMAS
3 EASTER
I need to represent this in a report in the following manner upto nth Event.
EVENT1 EVENT2 EVENT3 ...... EVENN
---------------------------------------------------------
NEW YEAR DAY CHRISTMAS EASTER Nth EVENT
I am using a Repeating Frame in the 'Across' order to do this.
My problem is that i need to port this report exactly the same way to a Excel sheet, i.e. in the Report i am displaying the rows in column order using a Repeating Frame in 'Page Across' order.
If i port this report to Excel will it come row wise in the Excel sheet or column wise. I want the rows in column wise in Excel sheet also as displayed above.
How can i port this report to an MS-Excel sheet by keeping the same order ?
If any one knows the solution please help, as it is very urgent.
I am using Oracle 8.0 Database and Reports 2.5, as my client is not willing to upgrade. So i need to work on the same platform.
Thanks and Regards,
Nirmal.
|
|
|
Re: How can i port this report to an MS-Excel sheet by keeping the same order ? [message #146018 is a reply to message #143784] |
Tue, 08 November 2005 03:43 |
eHeritage
Messages: 4 Registered: November 2005 Location: HYDERABAD
|
Junior Member |
|
|
Hi,
For exporting ur report data into excel u need to use different
printer file .
copy this code in notepad and save it as .prt file
/*****************/
printer "Excel"
height 5000
width 5000
code "500" control(I)
code "600" control(J)
/*****************/
and assign that printer file to desformat,
also u need to align the layout columns to fit to grid,
the first column u need to set printercodes as &500 and the last
column as &600.
|
|
|