| export report to excel [message #88392] |
Fri, 02 August 2002 02:15  |
Michel Oink
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
If I run the report and show it on screen the header is at the top of the report.
If I load the report to a flat file (.txt) then the header appears on every line.
What can I do about it???
|
|
|
|
| Re: export report to excel [message #88411 is a reply to message #88392] |
Tue, 20 August 2002 08:02  |
Jon Fulkerson
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
This may not be the best way, but it might help.
Remove any header fields in the layout model and add this bit of code to your query.
/**********************************/
union
select ' ColumnName1', -- the space is not a typo
'ColumnName2',
'ColumnName3'
from dual
order by 1
/*********************************/
The key is the space in front of ColumnName1. When the data is ordered, the space will go to the top, taking all the column headers with it.
Some of the downfalls is that all numbers and dates have to be converted to characters or else you get a datatype mismatch between the file-headings query and the original query. And of course you have a space in front of one of your columns. ;-)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
