 |
|
| MDDB Report Viewer 9.2 |
_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="../mddbapp.hlp/" 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="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $97,864</A></TD>
<TD CLASS="tdcell" BGCOLOR=#00FFFF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $149,126</A></TD>
<TD CLASS="tcolcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA')" TARGET="_blank"> $246,990</A></TD>
<TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1>
<A href="../mddbapp.hlp/" 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="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $101,194</A></TD>
<TD CLASS="tdcell" BGCOLOR=#00FFFF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $144,804</A></TD>
<TD CLASS="tcolcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY')" TARGET="_blank"> $245,998</A></TD>
<TR><TH CLASS="rowlab" NOWRAP ROWSPAN=1 COLSPAN=1>
<A href="../mddbapp.hlp/" 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="../mddbapp.hlp/" 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="../mddbapp.hlp/" 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="../mddbapp.hlp/" 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="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank"> $290,625</A></TD>
<TD CLASS="trowcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank"> $439,712</A></TD>
<TD CLASS="trowcell" BGCOLOR=#0000FF><A href="../mddbapp.hlp/" onClick="this.href=rturl
('_WHERE=')" TARGET="_blank"> $730,337</A></TD>
</TR></TABLE><BR><BR>
|
|
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.