Complex formatted out for html/ excel

[SuniGoel]

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.

[Vince_SAS]

What are the steps for producing the output for Excel, and for opening it with Excel?

Vince DelGobbo

SAS R&D

[Sarojknayak]

There two issues here.
1. Ods Tagset.excel is working in sas EG but not in WRS.
2. Dependency for cascading prompt works well in stored process but it fails when we use the same stored process in the WRS. As mentioned in the message above SAS environment is 9.2 version and SAS WRS is 4.3 version.

[Vince_SAS]

I think that SAS Web Report Studio only supports the SASREPORT* ODS destinations; you cannot use tagsets.ExcelXP.

In SAS 9.2 that would be SASREPORT11 or SASREPORT12.

Vince DelGobbo

SAS R&D

[Sarojknayak]

The stored process was added to the WRS report. When report generated in wrs, report was exported to excel or html. Here excel and HTML export do not follow the format shown in the report.