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?
