This discussion is archived
1 Reply Latest reply: Mar 19, 2013 8:18 AM by InoL RSS

Column Headers repeating in Oracle Reports 10g

453557 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points