When I am using the below code, I am seeing proper formatted reports in my EG but if I send it on email the columns are shrink and small. In my outlook email the output column is not aligned and formatted. When I am getting an option of how the message is displayed and to view it in a browser I am getting proper format and column width. IS there any way I can increase the size/width of column size. Is it code issue or email setting issue Proc Report data=BS1_Sample_code Missing split="*" nowd Style (report)= {just=left borderwidth=0.5 font =('zurich b',9PT) bordercolor=black font_size=2} Style (header)= {foreground=white background=blue font_size=2 font=('zurich b',9PT) fontweight=bold bordercolor=black} Style (column)= {just=center foreground=black font_size=2 borderwidth=0.5 borderstyle=solid bordercolor=black}; column ("Balance Sheet - Amount- (USD) in 1000's"(Entity_Cd Vs_Product VS_Product_L1 CURRENT_DAY_USD PREVIOUS_DAY_USD Variance Variance_per)); Define Entity_Cd/"ENTITY" group style={just=L cellwidth=0.9} ; Define Vs_Product/"Vs Product" group style={just=L cellwidth=0.9} ; Define VS_Product_L1/"VS_Product_L1" group style={just=L cellwidth=0.9} ; Define CURRENT_DAY_USD/analysis sum "11JUN2023 - AMOUNT USD" format= 20. style={just=r cellwidth=0.5}; Define PREVIOUS_DAY_USD/analysis sum "10JUN2023 - AMOUNT USD" format= 20. style={just=r cellwidth=0.5}; Define Variance/analysis sum "Variance" format= 20. style={just=r cellwidth=0.5}; Define Variance_per/"Variance %" computed format=percent8.2 style={just=r cellwidth=0.5}; compute Variance_per; Variance_per=(CURRENT_DAY_USD.sum-PREVIOUS_DAY_USD.sum)/PREVIOUS_DAY_USD.sum; endcomp; compute after Vs_Product; Vs_Product="Total"||''||Vs_Product; call define(_row_,"style","style={background=cxEEFFFF}"); endcomp; break after Vs_Product / dol skip summarize; rbreak after / style ={background=brown};
... View more
