To display customize lines through proc report

deleted_user — Wed, 03 Oct 2007 21:57:55 GMT

Hi,

Below there is my proc report code to generate a report:

options nocenter;

proc report data=WORK.QUERY8283 nowd headskip split='*' spacing=1 ;

column Gb_Br_Name
Ageing
Pi_In_Ordtype,
(''(Pi_In_Recgoods=Pi_In_Recgoods1))
Pi_In_Recgoods;

define Gb_Br_Name / group width=40 flow FORMAT=$30.;
define Ageing / group width=25 flow FORMAT=$25.;
define Pi_In_Ordtype / 'Order Type' across ;
define Pi_In_Recgoods1 / 'Value' FORMAT=COMMA16.2 ;
define Pi_In_Recgoods / 'Total*Value ' FORMAT=COMMA16.2;
rbreak after /summarize ol;
break after Ageing / suppress skip;
break after Gb_Br_Name / summarize ol suppress skip;
compute before _page_;
line @2 "&div"
@10 "&repnum"
&_CENT "&Rep_title"
@109 "&repdate";
line &_CENT &_LEN*'-';
endcomp;
compute after Gb_Br_Name ;
Ageing = 'Branch Total';

endcomp;
compute after;
Ageing ='Company Total';
_last_page=1;
endcomp;
compute after _page_;
_page+1;
if _last_page=1 then
text='End of Report';
else text='';
pagetxt='Page '||trim(left(_page));
line center pagetxt $20.;
line center text $20.;
endcomp;
run;

I am getting proper output the only problem is that it prints a line above branch total label and company total also which i want to suppress the line
I dont want to use Line statement in my code.
Any solution for this issue? Message was edited by: Sunil Gandhi

Re: To display customize lines through proc report

Cynthia_sas — Thu, 04 Oct 2007 03:49:48 GMT

Hi:
I'm having a hard time visualizing what your report is doing. Maybe try it without the SKIP in the 2 BREAK statements??

Otherwise, your best bet for help is to contact Tech Support. (Especially if you don't want to use ANY LINE statements in your code -- because right now it looks like you're using the LINE statement to write a pseudo TITLE and pseudo FOOTNOTE on each page.)

cynthia

topic Re: To display customize lines through proc report in ODS and Base Reporting

To display customize lines through proc report

Re: To display customize lines through proc report