| Column Headers repeating in Oracle Reports 10g [message #580015] |
Tue, 19 March 2013 05:39  |
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 #580035 is a reply to message #580028] |
Tue, 19 March 2013 09:48  |
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 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
