MDDB Report Viewer Methods

_OUTPUT_VARIABLE_SEL_FORM_ Method

Outputs the HTML table elements to arrange the Variable Selection page and calls the methods that output the variable and options HTML elements.

Syntax

  CALL SEND(OBJID,'_OUTPUT_VARIABLE_SEL_FORM_',url,msgid,vrflag,grphtype);

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

url C the broker component of the URL.

msgid N the ID number of the message system.

vrflag N a flag indicating that the View Report button was pressed.

grphtype C the selected graph type.

Example

The following example illustrates the output produced by this method:

<FORM ACTION="/cgi-bin/broker" NAME="mf">
<TR>
<TD VALIGN=TOP>
<TABLE>
<TR>
<TD CLASS=header>
Dimensions</TD>
</TR>
<TR CLASS="dimselbox">
<TD CLASS=label>
Down: <BR>
<SELECT NAME="d" CLASS="select" SIZE=3 MULTIPLE onChange="change(document.mf.d)">
<OPTION SELECTED VALUE=Geographic>Geographic (hier)
<OPTION VALUE=Product%2520Line>Product Line (hier)
<OPTION VALUE=Time>Time (hier)
<OPTION VALUE=COUNTRY>Country
<OPTION VALUE=DIVISION>Division
<OPTION VALUE=MONTH>Month
<OPTION VALUE=PRODTYPE>Product type
<OPTION VALUE=PRODUCT>Product
<OPTION VALUE=QUARTER>Quarter
<OPTION VALUE=REGION>Region
<OPTION VALUE=YEAR>Year
</SELECT>
</TD>
</TR>
<TR CLASS="dimselbox">
<TD CLASS=label>
Across: <BR>
<SELECT NAME="ac" CLASS="select" SIZE=3 MULTIPLE onChange="change(document.mf.ac)">
<OPTION SELECTED VALUE="">
<OPTION VALUE=Geographic>Geographic (hier)
<OPTION VALUE=Product%2520Line>Product Line (hier)
<OPTION VALUE=Time>Time (hier)
<OPTION VALUE=COUNTRY>Country
<OPTION VALUE=DIVISION>Division
<OPTION VALUE=MONTH>Month
<OPTION VALUE=PRODTYPE>Product type
<OPTION VALUE=PRODUCT>Product
<OPTION VALUE=QUARTER>Quarter
<OPTION VALUE=REGION>Region
<OPTION VALUE=YEAR>Year
</SELECT>
</TD>
</TR>
<TR><TD CLASS="label">Analysis
<DIV CLASS="analysis">
<SELECT NAME="a" CLASS="select" MULTIPLE SIZE=3 onChange="change(document.mf.a)">
<OPTION SELECTED VALUE=ACTUAL>Actual Sales
<OPTION VALUE=DIFF>Sales Lag
<OPTION VALUE=LPERDAY>LPERDAY
<OPTION VALUE=PREDICT>Predicted Sales
<OPTION VALUE=SALESRAT>Sales Ratio
</SELECT>
</DIV>
</TD>
</TR>
<TR><TD CLASS="label">Statistics
<DIV CLASS="stats">
<SELECT NAME="s" CLASS="select" MULTIPLE SIZE=3 onChange="change(document.mf.s)">
<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>
</TD>
</TR>
<TR><TD CLASS="label" ALIGN=LEFT>Filter Columns: <BR>
<SELECT NAME="SV" CLASS="select" MULTIPLE SIZE=3>
<OPTION VALUE="" SELECTED>
<OPTION VALUE="COUNTRY">Country
<OPTION VALUE="DIVISION">Division
<OPTION VALUE="MONTH">Month
<OPTION VALUE="PRODTYPE">Product type
<OPTION VALUE="PRODUCT">Product
<OPTION VALUE="QUARTER">Quarter
<OPTION VALUE="REGION">Region
<OPTION VALUE="YEAR">Year
</SELECT></TD></TR>
</TABLE>
</TD>
<TD ALIGN=CENTER VALIGN=TOP>
<TABLE>
<TR>
<TD COLSPAN=2 CLASS=header>
Table</TD>
</TR>
<TR><TD CLASS="label">Display Table</TD>
<TD>
<INPUT NAME="ST" CLASS="select" TYPE=RADIO VALUE="1" CHECKED>Yes
<INPUT NAME="ST" CLASS="select" TYPE=RADIO VALUE="2">No
</TD>
</TR>
<TR>
<TD CLASS="label">Default Title</TD>
<TD><INPUT NAME="DT" CLASS="select" TYPE=TEXT SIZE=30 MAXLENGTH=200></TD>
</TR>
<TR>
<TD CLASS="label">Show Drillpath</TD>
<TD>
<INPUT NAME="DP" CLASS="select" TYPE=RADIO VALUE="1" CHECKED>Yes
<INPUT NAME="DP" CLASS="select" TYPE=RADIO VALUE="2">No
</TD>
</TR>
<TR><TD CLASS="label">Show Totals</TD>
<TD><INPUT TYPE="checkbox" NAME="dc" CLASS="select" VALUE="1" CHECKED>Down
<INPUT TYPE="checkbox" NAME="acb" CLASS="select" VALUE="1" CHECKED>Across</TD></TR>
<TR>
<TD COLSPAN=2 CLASS=header>
Graph</TD>
</TR>
<TR><TD CLASS="label">Graph Source</TD>
<TD>
<INPUT NAME="GSC" CLASS="select" TYPE=RADIO VALUE="1" CHECKED>3D Clickable Graph
<INPUT NAME="GSC" CLASS="select" TYPE=RADIO VALUE="2">Standard GIF Graph
</TD>
</TR>
<TR><TD CLASS="label">Location</TD>
<TD><SELECT NAME="gl" CLASS="select"><OPTION VALUE="1" SELECTED>Bottom
<OPTION VALUE="2">Top
<OPTION VALUE="3">Left
<OPTION VALUE="4">Right
</SELECT></TD></TR>
<TR><TD CLASS="label">Type</TD>
<TD><SELECT NAME="grt" CLASS="select">
<OPTION SELECTED VALUE=NONE>None
<OPTION VALUE=VBAR>Vertical bar
<OPTION VALUE=BLOCK>Block
<OPTION VALUE=HBAR>Horizontal bar
<OPTION VALUE=PIE>Pie
<OPTION VALUE=PLOT>Plot
</SELECT>
</TD>
</TR>
<TR><TD CLASS="label">Width</TD><TD><INPUT TYPE=text NAME="gw" CLASS="select" SIZE=4 MAXLENGTH=4 VALUE="600"></TD></TR>
<TR><TD CLASS="label">Height</TD><TD><INPUT TYPE=text NAME="gh" CLASS="select" SIZE=4 MAXLENGTH=4 VALUE="450"></TD></TR>
<TR>
<TD COLSPAN=2 CLASS=header>
Filter Listboxes</TD>
</TR>
<TR><TD CLASS="label">Location</TD>
<TD><SELECT NAME="ssl" CLASS="select"><OPTION VALUE="1" SELECTED>Right
<OPTION VALUE="2">Left
<OPTION VALUE="3">Top
<OPTION VALUE="4">Bottom
</SELECT></TD></TR>
<TR><TD CLASS="label">Width</TD><TD><INPUT TYPE=text NAME="sw" CLASS="select" SIZE=3 MAXLENGTH=3 VALUE="15"></TD></TR>
<TR><TD CLASS="label">Height</TD><TD><INPUT TYPE=text NAME="sh" CLASS="select" SIZE=3 MAXLENGTH=3 VALUE="3"></TD></TR>
</TD>
</TR>
</TABLE>
<TR>
<TD ALIGN=CENTER COLSPAN=2>
<INPUT TYPE="submit" NAME="view" CLASS="submit" VALUE="View Report">
</TR>
</TD>

MDDB Report Viewer Methods