MDDB Report Viewer 9.2 |
CALL SEND(OBJID,'_OUTPUT_SPREADSHEET_URL_',vrflag,url,service-name, analysis-variable,statistic,down-variable,graph-type, background-type,background-value,title,webeis-class);
Where... | Is Type... | And Contains... |
---|---|---|
vrflag | N | the View Report button flag. |
url | C | the broker component of the URL. |
service-name | C | the broker service value. |
analysis-variable | C | the analysis variable that is to be graphed. |
statistic | C | the statistic that is to be graphed. |
down-variable | C | the down variable that is to be graphed. |
graph-type | C | the graph type (BLOCK, HBAR, PIE, PLOT, VBAR). |
background-type | C | the background type (IMAGE or COLOR). This parameter is optional. |
background-value | C | the background value. This parameter is optional. |
title | C | the HTML page title. |
webeis-class | C | the WEBEIS class name. |
The following example illustrates the use of this method:
vrflag=1; url='/cgi-bin/broker'; service='default'; grphvar='ACTUAL'; grphstat='SUM'; grphdown='COUNTRY'; grphtype='VBAR'; bgtype='COLOR'; bg='yellow'; title='1995 Sales Report'; webcls='SASHELP.WEBEIS.WEBEIS'; call send(_self_,'_OUTPUT_SPREADSHEET_URL_',vrflag,url,service,grphvar,grphstat, grphdown,grphtype,bgtype,bg,title,webcls);
The following output is produced:
downloadURL="http://mywebserver/cgi-bin/broker/prdmddb.csv?_service=default&_debug=0 &_program=sashelp.webeis.oprpt.scl&SPDSHT=X&mddb=SASHELP.PRDMDDB&metabase=SASHELP &D=COUNTRY&AC=YEAR&A=ACTUAL&A1S1=SUM&DC=1&ACB=1&ST=1&GL=1&GSC=1&SSL=1&SH=3&SW=15 &GH=450&GW=600&DP=1&NR=ALL&BS=Star&_SAVEAS=prdmddb.csv"
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.