_DISPLAY_VALUES_ Method

Outputs the numerical values to the report table

This method

calls the _GET_DATA_ATTR_ method of the METABASE class to get the base table name for reach-through
calls the _GET_EXPANDABLE_CLASS_ method of the data model to get the expand variable
calls the EMDDB_M _SET_ACTIVE_VALUE_ method
calls the EMDDB_M _SET_ACTION_STATUS_ method to validate drilldown
outputs the class value for the current row
outputs an <A> tag if drilldown is valid
outputs the expand link if the expand is valid
outputs the collapse link if the collapse is valid
calls the EMDDB_M _GET_VALUES_ method to get the numerical value of the current statistic/analysis pair
calls the _GET_ANALYSIS_VAR_NAME_ method
calls the metabase _GET_VAR_ATTR_ method to get the variable attributes
calls the _GET_RANGE_COLOR_ method if a range is applied
calls the EMDDB_M _GET_CLASS_FORMAT_ method
outputs the numerical value to a table cell
calls the _OUTPUT_REACHTHRU_LINK_ method if the reach-through to detail is valid
outputs the closing HTML table tag.

Syntax

 CALL SEND(OBJID,'_DISPLAY_VALUES_',row-list,column-list,
       actions-list,metabase-id,viewreport-flag,_url,_argument-string,
       _argument-string2,initial-url,analysis-variable,statistic-variable,
         across-variable,background-type,background-value,title,webcls,dlflag);

Where... Is Type... And Contains...

row-list N the Row list from EMDDB_M.

column-list N the column list from EMDDB_M.

actions-list N the actions sublist that determines drilldown.

metabase-id N the metabase ID number.

viewreport-flag N the View Report button flag.

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

analysis-variable C the analysis variable that is to be graphed.

statistic-variable C the statistic that is to be graphed.

across-variable N the analysis variable that is to be graphed.

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, and 1 = output data values with spreadsheet delimiters.

Example

rowlist=makelist(); call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','ROW',rowlist); collist=makelist(); call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','COL',collist); actionsl=makelist(); rc=insertc(actionsl,'',-1,'CL_DRILL'); mbid=instance(loadclass('SASHELP.MB.METABASE')); vrflag=1; _url='/cgi-bin/broker?_PROGRAM=sashelp.webeis.mddbrpts.scl&_SERVICE=default &_DEBUG=0&RPTTYPE=2&GRTYPE=BLOCK'; _args='&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&DOWN=Geographic&ACROSS =Product+Line&A=ACTUAL'; _args2='&S=SUM'; grphvar=''; grphstat=''; grphacr='PRODTYPE'; bgtype='color'; bg='yellow'; title=''; webcls='SASHELP.WEBEIS.WEBEIS'; dlflag=0; call send(_self_,'_DISPLAY_VALUES_',rowlist,collist,actionsl,mbid,vrflag, _url,_args,_args2,mddblink,grphvar,grphstat,grphacr, bgtype,bg,title,webcls,dlflag);

The following output is produced:
<TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1> <A HREF="" onClick="this.href=clsurl('V11=COUNTRY=CANADA&V10=1 &_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">CANADA</A> </TH> <TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1> <A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default &_DEBUG=0&GRT=NONE&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS &D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM &EX=1&EX=COUNTRY=CANADA&DC=1&ACB=1&ST=1&GL=1&GSC=1 &SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic &PAC=Product%2BLine&BGTYPE=color&BG=%23FFFFE7" TARGET="_top"> <IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH> <TD CLASS="tdcell" BGCOLOR=#008000><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $97,864</A></TD> <TD CLASS="tdcell" BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $149,126</A></TD> <TD CLASS="tcolcell" BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DCANADA')" TARGET="_blank"> $246,990</A></TD> <TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1> <A HREF="" onClick="this.href=clsurl ('V11=COUNTRY=GERMANY&V10=1&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">GERMANY</A> </TH> <TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1> <A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default &_DEBUG=0&GRT=NONE&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS &D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM &EX=1&EX=COUNTRY=GERMANY&DC=1&ACB=1&ST=1&GL=1&GSC=1 &SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine &BGTYPE=color&BG=%23FFFFE7" TARGET="_top"> <IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH> <TD CLASS="tdcell" BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $101,194</A></TD> <TD CLASS="tdcell" BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $144,804</A></TD> <TD CLASS="tcolcell" BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DGERMANY')" TARGET="_blank"> $245,998</A></TD> <TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1> <A HREF="" onClick="this.href=clsurl('V11=COUNTRY=U.S.A.&V10=1 &_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">U.S.A.</A> </TH> <TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1> <A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default &_DEBUG=0&GRT=NONE &MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&D=Geographic&AC=Product%20Line &A=ACTUAL&S=SUM &EX=1&EX=COUNTRY=U.S.A.&DC=1&ACB=1&ST=1&GL=1&GSC=1&SSL=1 &SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine &BGTYPE=color&BG=%23FFFFE7" TARGET="_top"> <IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH> <TD CLASS="tdcell" BGCOLOR=#008000><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DU.S.A.&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $91,567</A></TD> <TD CLASS="tdcell" BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DU.S.A.&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $145,782</A></TD> <TD CLASS="tcolcell" BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl ('_WHERE=COUNTRY%3DU.S.A.')" TARGET="_blank"> $237,349</A></TD> <TR><TH CLASS="trowlab" ROWSPAN=1 COLSPAN=1>TOTAL</TH> <TH CLASS="trowlab" COLSPAN=1 ROWSPAN=1> <A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default &_DEBUG=0&GRT=NONE &MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&D=Geographic &AC=Product%20Line&A=ACTUAL&S=SUM &EX=1&EX=COUNTRY=TOTAL&DC=1&ACB=1&ST=1&GL=1&GSC=1 &SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine &BGTYPE=color&BG=%23FFFFE7" TARGET="_top"> <IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH> <TD CLASS="trowcell" BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl ('_WHERE=&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $290,625</A></TD> <TD CLASS="trowcell" BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl ('_WHERE=&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $439,712</A></TD> <TD CLASS="trowcell" BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl ('_WHERE=')" TARGET="_blank"> $730,337</A></TD> </TR></TABLE><BR><BR>

Where...	Is Type...	And Contains...
row-list	N	the Row list from EMDDB_M.
column-list	N	the column list from EMDDB_M.
actions-list	N	the actions sublist that determines drilldown.
metabase-id	N	the metabase ID number.
viewreport-flag	N	the View Report button flag.
_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.
analysis-variable	C	the analysis variable that is to be graphed.
statistic-variable	C	the statistic that is to be graphed.
across-variable	N	the analysis variable that is to be graphed.
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, and 1 = output data values with spreadsheet delimiters.