MDDB Report Viewer 9.2

_OUTPUT_SPREADSHEET_BUTTON_ Method

Outputs the Download to Spreadsheet button as an image

Syntax

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

Where...	Is Type...	And Contains...
vrflag	N	a flag indicating that the View Report button was pressed.
url	C	the broker path.
service	C	the broker service that is being used.
grphvar	C	the analysis variable that is to be graphed.
grphstat	C	the statistic that is to be graphed.
grphdown	C	the down dimension variable that is to be graphed.
grphtype	C	the graph type.
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 title. This parameter is optional.
webcls	C	the WEBEIS class name (for subclassing).

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>

Top of Page