I've seen this done, but I didn't find any documentation on how to do it. I have a small ad-hoc page that I would like to add a drop down list for the user to select the Top 5,10,15,20 or 25 items. However, I'm not sure what kind of variable to use and/or how to place it in the code or on the GUI.

I am now using 7.7.03 although we haven't officially gone to production on this version.

 DEFINE FILE DASHBOARD
NET_UNITS/I11C=DASHBOARD.SEG01.U_PURCHASED- DASHBOARD.SEG01.U_RETURNED;
NET_DOLLARS/D12.2CM=DASHBOARD.SEG01.P_DOLLARS- DASHBOARD.SEG01.R_DOLLARS;
GP_PCT/D12.2%=DASHBOARD.SEG01.GP_DOLLARS / NET_DOLLARS*100;
END
TABLE FILE DASHBOARD
SUM
     &Measures.(AND(<Quantity,DASHBOARD.SEG01.NET_UNITS>,<Sales Dollars,DASHBOARD.SEG01.NET_DOLLARS>,<GP Dollars,DASHBOARD.SEG01.GP_DOLLARS>,<GP %,DASHBOARD.SEG01.GP_PCT>)).Select Measures.
BY  LOWEST &Sorts.(BY(<Category,DASHBOARD.SEG01.CATEGORY>,<Segment,DASHBOARD.SEG01.C_SEGMENT>,<Brand Group,DASHBOARD.SEG01.BRAND_GROUP>,<Brand,DASHBOARD.SEG01.BRAND>,<Pattern,DASHBOARD.SEG01.PATTERN>,<Rim Size,DASHBOARD.SEG01.RIM_SZ>,<Tire Size,DASHBOARD.SEG01.TIRE_SZ>)).Select Sorts.
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=REPORT,
     GRAPHCOLOR='GREEN',
$
TYPE=REPORT,
     OBJECT=MENU,
     COLOR='WHITE',
     HOVER-COLOR=RGB(66 70 73),
     BACKCOLOR=RGB(102 102 102),
     HOVER-BACKCOLOR=RGB(218 225 232),
     BORDER-COLOR='WHITE',
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
$
TYPE=REPORT,
     OBJECT=CURRENT-ROW,
     HOVER-BACKCOLOR=RGB(218 225 232),
     BACKCOLOR=RGB(200 200 200),
$
TYPE=REPORT,
     OBJECT=CALC-AREA,
     COLOR='WHITE',
     BACKCOLOR=RGB(102 102 102),
$
ENDSTYLE
END
 

This message has been edited. Last edited by: Kerry,

Of course as soon as I post the question, then I think of something else to try. For anyone else who might be interested:

All of this was done in the GUI.

I had to use my &Measures variable and "Order Report by" this field.

Then in the NOPRINT field that is created after the above step, go in to the options for that field and click on the Sort tab. There are options to variablize (is that a word?) the ranking and the lowest/highest designation.

Report Painter allows Rank to be set as a variable and that would give you this as well.

quote:

There are options to variablize (is that a word?) the ranking ...

I think the word you are looking for is "vary" ....

This message has been edited. Last edited by: George Patton,