Contents MDDB Report Viewer Methods Previous Next
 

_DISPLAY_STATISTIC_VARS_ Method

Outputs the selected statistics to the report table. This method

  • outputs a <TH> tag for each statistic in the column list

  • outputs a selection list of statistics on the first occurrence of each selected statistic

  • outputs an <A> tag followed by an <IMAGE> tag for each statistic if the standard GIF graph is displayed.

Syntax

 CALL SEND(OBJID,'_DISPLAY_STATISTIC_VARS_',column-list,analysis-variable,
          _url,_argument-string,_argument-string2,initial-url,URL,service,background-type,
          background-value,title,webcls,dlflag,rowlist);

Where... Is Type... And Contains...
column-list N the column list from the EMDDB_M class.
analysis-variable N the analysis variable to be graphed.
_url C the URL of the next query.
_argument-string C the argument string for the next query.
_argument-string2 C the argument string for the next query.
initial-url C the URL of the initial HTML page.
URL C the broker component of the URL.
service C the broker service being used.
background-type C the background type (IMAGE or COLOR); this value is optional.
background-value C the background value; this value is optional.
title C the HTML page title.
webcls C the WEBEIS class name.
dlflag N a flag that indicates whether to download the table to a spreadsheet, where 0 = output HTML tags with data values; 1 = output data values with spreadsheet delimiters. This parameter is optional.
rowlist N the rowlist from the _GET_CLASS_COMBINATIONS_ method. This parameter is optional.

Example

call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','COL',collist);
call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','ROW',rowlist);
_url='/cgi-bin/scripts?_PROGRAM=SASHELP.WEBEIS.MDDBRPTS.SCL&_SERVICE=default
&_DEBUG=0&RPTTYPE=1&GRTYPE=BLOCK';
_args='&MDDB=PERMDATA.MAPINFO&METABASE=PERMDATA.MB612&DOWN=Geographic&A=ACTUAL';
_args2='&S0=2&S1=SUM&S2=PCTSUM';
mddblink='DYNAMIC';
url='/cgi-bin/broker';
service='default';
bgtype='color';
bg='yellow';
title='';
webcls='SASHELP.WEBEIS.WEBEIS';
call send(webid,'_DISPLAY_STATISTIC_VARS_',collist,'',_url,_args,            
          _args2,mddblink,url,service,bgtype,bg,title,webcls,dlflag,rowlist);  
The example produces the following output:
<TH CLASS="statscol" VALIGN=BOTTOM><DIV CLASS="stats">
<SELECT NAME="s" CLASS="statsbox" onChange="submit();">
<OPTION VALUE="SUM" SELECTED>Sum
<OPTION VALUE="PCTSUM">% of Sum
<OPTION VALUE="AVG">Average
<OPTION VALUE="N">Total Count
<OPTION VALUE="PCTN">% of Total #
<OPTION VALUE="MIN">Minimum
<OPTION VALUE="MAX">Maximum   
<OPTION VALUE="RANGE">Range
</SELECT>
</DIV>
</TH>
<TH CLASS="statscol" VALIGN=BOTTOM><DIV CLASS="stats">
<SELECT NAME="s" CLASS="statsbox" onChange="submit();">
<OPTION VALUE="SUM">Sum
<OPTION VALUE="PCTSUM" SELECTED>% of Sum
<OPTION VALUE="AVG">Average
<OPTION VALUE="N">Total Count
<OPTION VALUE="PCTN">% of Total #
<OPTION VALUE="MIN">Minimum
<OPTION VALUE="MAX">Maximum
<OPTION VALUE="RANGE">Range
</SELECT>
</DIV>


Contents MDDB Report Viewer Methods Previous Next