Hi All, I am using SAS 9.2 with WRS 4.3 version. We are using stored procedures to generate report. However, the major problems are 3-fold. 1) HTML numeric values are left aligned. 2) In excel, -ve numeric values are left aligned instead of right (while +ve values are correctly right aligned). 3) Lastly, cascaded dynamic user filter values in WRS are not coming. The below is the code: ODS HTML FILE='RTGS.HTML' style=sasweb; proc report data= TEST_final nowd split='#' OUT=TEST_final1 style(report)=[bordercolor= black background=_undef_ rules=rows frame = void] style(header)=[font_face="Arial" font_size=11pt borderrightwidth=0.2pt borderbottomwidth=0.2pt bordertopwidth=0.2pt borderleftwidth=0.2pt ] style(column)=[borderrightwidth=0.2pt borderbottomwidth=0.2pt bordertopwidth=0.2pt borderleftwidth=0.2pt] style(lines)=[font_face="Arial" font_size=11pt]; Title; column ('Debit' ('Name of the Work/Head of Account' DEBIT_DESC) AmountDR) ("" ONE) ('Credit'( ('Head of Account' Subdept)('Name of Work' DESCRIPTION) GLCR) AmountCR); define SubDept/ group center order=data "" Width=20; define Description / group "" Width=20; define DEBIT_DESC / "" display Width=50; define GLCR / order"GL Code" center Width=30; define ONE / '' width=10 format=$1.; define AmountDR/ style(column)={just=r} 'Amount Debit' analysis sum format=comma22.2; define AmountCR/ style(column)={just=r} 'Amount Credit' analysis sum format=comma22.2; BREAK AFTER Subdept / SUMMARIZE Suppress dol dul style(summary)={font_weight=bold font_style=roman}; RBREAK AFTER / SUMMARIZE dol dul style(summary)={font_weight=bold font_style=roman}; compute after Subdept; AmountDR.sum = ''; GLCR='Sub Total'; endcomp; compute after ; Description = 'Total'; DEBIT_DESC='Total'; endcomp; run; ODS html close; Any urgent help will be really very very appreciated.
... View more