Contents MDDB Report Viewer Methods Previous Next

_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"

Contents MDDB Report Viewer Methods Previous Next