OraFAQ Forum: Reports & Discoverer » reports heading displayed many times in excel

Home » Developer & Programmer » Reports & Discoverer » reports heading displayed many times in excel

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

reports heading displayed many times in excel [message #132388]

Fri, 12 August 2005 07:46

priyravi
Messages: 41
Registered: July 2005

Member

hi

i have a report i have a txt field as "report1" as the heading....when i run the form in web its working fine. when i try to convert the report into csv , the csv is generated without any problem but the report heading(report1) which i have set is displayed all times.ie... for each row in the report it is displayed ,,,but i need it to be displayed only once

report1 1
report1 2
report1 3

i need it as

report1
1
2
3

Report message to a moderator

Re: reports heading displayed many times in excel [message #132652 is a reply to message #132388]

Mon, 15 August 2005 09:08

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Hi Priyravi,

Is it a crosstab (matrix) report or a tabular one?

Regards,
Sabine

Report message to a moderator

Re: reports heading displayed many times in excel [message #163807 is a reply to message #132388]

Mon, 20 March 2006 02:33

grasya
Messages: 6
Registered: March 2006
Location: phils

Junior Member

I had similar problems....

Try to cut the header in the Main section of the Layout editor then paste it in the Header section..

Then create the .csv and see what happens... ^_^

Report message to a moderator

Re: reports heading displayed many times in excel [message #193281 is a reply to message #163807]

Fri, 15 September 2006 09:47

nenadj
Messages: 9
Registered: September 2006

Junior Member

Somebody had right solution for this problem?
It is an tabular that I am trying to output as a .cvs
and I get also results like:
Employer;Employee;Jones;Smith...
Employer;Employee;Lang;Carrie ...
instead I need:
Employer;Employee
Jones;Smith
Lang;Carrie
.. ...
The properties are set to print on the first page
only for all frames/ fields.
I run Report Builder 6.0

[Updated on: Fri, 15 September 2006 10:15]

Report message to a moderator