MDDB Report Viewer 9.2

_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
a selection list of statistics on the first occurrence of each selected statistic
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 that is 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 that is 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>

Top of Page