_OUTPUT_SPREADSHEET_BUTTON_ Method

Outputs the Download to Spreadsheet button as an image
Syntax
Example

Syntax

CALL SEND(OBJID,'_OUTPUT_SPREADSHEET_BUTTON_',vrflag,url, service,grphvar,
grphstat,grphdown,grphtype, bgtype,bg,title,webcls);

Required Arguments

vrflag
a flag indicating that the View Report button was pressed.
Type:Numeric
url
the Application Broker path.
Type:Character
service
the Application Broker service.
Type:Character
grphvar
the analysis variable to graph.
Type:Character
grphstat
the statistic to graph.
Type:Character
grphdown
the down dimension variable to graph.
Type:Character
grphtype
the graph type.
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 title. This parameter is optional.
Type:Character
webcls
the WEBEIS class name (for subclassing).
Type:Character

Example

The following example code 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=' ';
webcls=' ';
call send (webid,'_OUTPUT_SPREADSHEET_BUTTON_',vrflag,url,service,grphvar,
           grphstat,grphdown,grphtype,bgtype,bg,title,webcls);
The following output is produced:
<A HREF="/cgi-test-bin/broker/prdmddb.csv?_service=default&_debug=0
   &_program=sashelp.webeis.oprpt.scl&SPDSHT=X&mddb=SASHELP.PRDMDDB&metabase
   =SASHELP.MBEIS&D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM&ST=1&GL=1
   &DC=1&ACB=1&DP=1&_SAVEAS=prdmddb.csv" TARGET="_self"><IMG CLASS="imgdown" 
   SRC="/my_images/btn_xls.gif"ALT="Download to Spreadsheet" BORDER=0></A>
Copyright © SAS Institute Inc. All rights reserved.