_OUTPUT_SPREADSHEET_URL_ Method

Outputs the URL for the Download to Spreadsheet button as a JavaScript text string on the Report page

Syntax

 
      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.

Example

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"