_OUTPUT_SPREADSHEET_URL_ Method

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

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);

Required Arguments

vrflag
the View Report button flag.
Type:Numeric
url
the Application Broker component of the URL.
Type:Character
service-name
the Application Broker service value.
Type:Character
analysis-variable
the analysis variable to graph.
Type:Character
statistic
the statistic to graph.
Type:Character
down-variable
the down variable to graph.
Type:Character
graph-type
the graph type (BLOCK, HBAR, PIE, PLOT, or VBAR).
Type:Character
background-type
the background type (IMAGE or COLOR). This parameter is optional.
Type:Character
background-value
the background value. This parameter is optional.
Type:Character
title
the HTML page title.
Type:Character
webeis-class
the WEBEIS class name.
Type:Character

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"
Copyright © SAS Institute Inc. All rights reserved.