Home » Developer & Programmer » Reports & Discoverer » Column Headers repeating in Oracle Reports 10g (Report Builder 9.0.4.0.33)
Column Headers repeating in Oracle Reports 10g [message #580015] Tue, 19 March 2013 05:39 Go to next message
prashanth7582
Messages: 34
Registered: October 2005
Location: Bangalore
Member
Dear All,

I'm using Report Builder 9.0.4.0.33.

I am creating a report which generates the data to a PDF/CSV based on users Input.When I create the report using Report Builder and execute the report,Delimited data appears in a PDF layout.

But if I add the below code in After Parameter Form trigger,the column headers keeps repeating with the data.

Code:

function AfterPForm return boolean is
begin
IF :P_DESTYPE = 'CSV' THEN
:MODE :='DEFAULT';
:DESFORMAT:='DELIMITED';
Elsif :P_DESTYPE = 'PDF' THEN
:DESTYPE := 'CACHE';
:DESFORMAT:='PDF';
END IF;
return (TRUE);
end;


Output :

LOGON;NAME;START_TIME;END_TIME;NO_OF_LINES;ORDER_NO;NO_OF_CASES 007354;Alex Wheelhouse;01-JAN-2013 22:16:30;01-JAN-2013 22:25:28;8;6083885;70
LOGON;NAME;START_TIME;END_TIME;NO_OF_LINES;ORDER_NO;NO_OF_CASES 116529;Ramlal Vara;01-JAN-2013 22:20:38;01-JAN-2013 22:37:18;10;6083886;65
LOGON;NAME;START_TIME;END_TIME;NO_OF_LINES;ORDER_NO;NO_OF_CASES 007412;Jack Lisemore;01-JAN-2013 23:27:34;01-JAN-2013 23:33:41;2;6083911;40
LOGON;NAME;START_TIME;END_TIME;NO_OF_LINES;ORDER_NO;NO_OF_CASES 007373;Gary Henson;01-JAN-2013 23:35:15;01-JAN-2013 23:47:59;3;6083912;80
LOGON;NAME;START_TIME;END_TIME;NO_OF_LINES;ORDER_NO;NO_OF_CASES 220368;Gary Owens;01-JAN-2013 23:36:11;01-JAN-2013 23:49:05;6;6083913;69

But the PDF output seems fine where the header is shown only once.I could see many posts regarding this in Oracle reports 6i wherein delimited_hdr=no is used in Command Line but I would like to know the work around in Oracle reports 10g.

Thanks for the support in advance.
Re: Column Headers repeating in Oracle Reports 10g [message #580028 is a reply to message #580015] Tue, 19 March 2013 08:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you need column labels at all? What do you use them for in a CSV format file? I'd remove them completely and have column values ONLY as the output.
Re: Column Headers repeating in Oracle Reports 10g [message #580035 is a reply to message #580028] Tue, 19 March 2013 09:48 Go to previous messageGo to next message
prashanth7582
Messages: 34
Registered: October 2005
Location: Bangalore
Member
Hi Littlefoot,

The client wants the Column names including the Parameters entered such as Start Time.
Ex:

Report executed at : 19/Mar/2013
InputTime is : 19/Mar/2013 10:45 and 19/Mar/2013 12:00
LOGON;NAME;START_TIME;END_TIME;NO_OF_LINES;ORDER_NO;NO_OF_CASES
116529;Ramlal Vara;01-JAN-2013 22:20:38;01-JAN-2013 22:37:18;10;6083886;65
Jack Lisemore;01-JAN-2013 23:27:34;01-JAN-2013 23:33:41;2;6083911;40

Above is how we need the output.Also we have the same report with different layout for PDF so we cannot change the Query to include the Column names as part of Output.Hope I communicated.
Thanks.
Re: Column Headers repeating in Oracle Reports 10g [message #580038 is a reply to message #580035] Tue, 19 March 2013 11:22 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea, sorry.

Did you consider having 2 reports, one for CSV and one for PDF output? That way you'd have a better control of what you want to do. As long as it is nice to reuse code (why having 2 reports if 1 can do the job?), sometimes it just make things complex and you are happier with 2 separate solutions.
Previous Topic: Global Cursor
Next Topic: How to create text file of report in 10g ?
Goto Forum:
  


Current Time: Fri Mar 29 08:58:55 CDT 2024