|
|
MDDB Report Viewer Methods |
|
This method
calls the _SET_ACTIVE_VALUE_ method of the EMDDB_M class
calls the _SET_ACTION_STATUS_ method of the EMDDB_M class
outputs the class values for the across dimension with <A> tags for drill down, if drill down is valid.
CALL SEND(OBJID,'_DISPLAY_ACROSS_CELLS_',column-list,actions-list,
view-report-flag,analysis-variable,statistic-variable,
across-variable,url,argument-string,argument-string2,
initial-url,background-type,background-value,title,
webeis-class,dlflag,service);
| Where... | Is Type... | And Contains... |
|---|---|---|
| column-list | N | the column list from the emddb_m class. |
| actions-list | N | the actions sublist for drill down. |
| view-report-flag | N | the flag for the View Report button. |
| analysis-variable | C | the analysis variable to be graphed. |
| statistic | C | the statistic to be graphed. |
| across-variable | C | the analysis variable for graphing. |
| url | C | the broker component of the URL. |
| 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. (This parameter is obsolete. It is included in the method statement so that overrides are not broken.) |
| background-type | C | the optional background type (IMAGE or COLOR). |
| background-value | C | the optional background value. |
| title | C | the HTML page title. |
| webeis-class | 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. |
| service | C | the service name. |
emddbmid= instance(loadclass('SASHELP.WEBEIS.EMDDB_M.CLASS');
collist= makelist();
call send(emddbmid,'_GET_CLASS_COMBINATIONS_','COL',collist);
actionsl= makelist();
rc= insertc(actionsl,'',-1,'CL_DRILL');
vrflag= 1;
grphvar= 'Actual Sales';
grphstat= 'Sum';
grphacr= 'Month';
url= 'cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.MDDBRPTS.SCL&_SERVICE=
default&_debug=&0GRT=BLOCK';
args= '&MDDB=SASUSER.SALES&METABASE=SASUSER.NEWMB&D=COUNTRY&AC=
=MONTH&A0=2&A1=ACTUAL&A2=PREDICT';
args2= '&S0=2&S1=SUM&S2=AVG';
bgtype= 'COLOR';
bg= 'YELLOW';
title= '1996 Sales Reports';
webcls= 'SASHELP.WEBEIS.WEBEIS.CLASS';
dlflag=0;
service='DEFAULT';
call send(webid,'_DISPLAY_ACROSS_CELLS_',collist,actionsl,vrflag,grphvar,
grphstat,grphacr,url,args,args2,' ',bgtype,bg,title,webcls,dlflag,service);
The example produces the following output:
<TR> <TH CLASS="COLLAB" COLSPAN=1>Month</TH> <TH CLASS="COLLAB" COLSPAN=4>Jan</TH> <TH CLASS="COLLAB" COLSPAN=4>Feb</TH> <TH CLASS="COLLAB" COLSPAN=4>Mar</TH> <TH CLASS="COLLAB" COLSPAN=4>Apr</TH> <TH CLASS="COLLAB" COLSPAN=4>May</TH> <TH CLASS="COLLAB" COLSPAN=4>Jun</TH> <TH CLASS="COLLAB" COLSPAN=4>Jul</TH> <TH CLASS="COLLAB" COLSPAN=4>Aug</TH> <TH CLASS="COLLAB" COLSPAN=4>Sep</TH> <TH CLASS="COLLAB" COLSPAN=4>Oct</TH> <TH CLASS="COLLAB" COLSPAN=4>Nov</TH> <TH CLASS="COLLAB" COLSPAN=4>Dec</TH> <TH CLASS="TCOLLAB" COLSPAN=4>TOTAL</TH> </TR>
|
|
MDDB Report Viewer Methods |
|