I have a Guided Ad-Hoc report where i am allowing user to select measure(s) and sort coulmn(s) from two different select boxes.
How can i include a filter option as well to this report for user to specify ( =,<>,>,< etc dynamically at run time) if they want to on the report on either a measure or a sort column.

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

Hi,

You could do something like below (AUTOPROMPTING must be on).
The next challenge is how to style the HTML-prompting page that it doesn't look so "Sovjet".

-Fred-

TABLE FILE CAR
SUM
     &MEASURE1.(<--- No selection ---,_FOC_NULL>,<DealerCost,CAR.BODY.DEALER_COST>,<RetailCost,CAR.BODY.RETAIL_COST>,<Sales,CAR.BODY.SALES>).Measure1.
WHERE &MEASURE1  &CON_MEASURE1.(GE,GT,LE,LT,EQ).ConditionMeasure1. &MEASURE1VALUE;
BY  &BY1.(<--- No selection ---,_FOC_NULL>,<Country,CAR.ORIGIN.COUNTRY>,<Car,CAR.COMP.CAR>,<Model,CAR.CARREC.MODEL>,<Bodytype,CAR.BODY.BODYTYPE>).By1.
BY  &BY2.(<--- No selection ---,_FOC_NULL>,<Country,CAR.ORIGIN.COUNTRY>,<Car,CAR.COMP.CAR>,<Model,CAR.CARREC.MODEL>,<Bodytype,CAR.BODY.BODYTYPE>).By2.

WHERE CAR.ORIGIN.COUNTRY &CON_CTRY.(EQ,NE).ConditionCountry. &COUNTRY.(OR(FIND CAR.ORIGIN.COUNTRY,CAR.ORIGIN.COUNTRY IN car)).Country.;
WHERE CAR.COMP.CAR &CON_CAR.(EQ,NE).ConditionCar. &CAR.(OR(FIND CAR,CAR.COMP.CAR IN car)).Car.;
WHERE CAR.BODY.BODYTYPE &CON_BTYPE.(EQ,NE).ConditionBodytype. &BODYTYPE.(OR(FIND CAR.BODY.BODYTYPE,CAR.BODY.BODYTYPE IN car)).Bodytype.;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
TYPE=REPORT     ,BORDER=1    ,BORDER-COLOR=RGB(210 210 210) ,$
TYPE=TITLE      ,STYLE=BOLD  ,BACKCOLOR=RGB(230 230 230)    ,$
TYPE=ACROSSTITLE,STYLE=BOLD  ,BACKCOLOR=RGB(230 230 230)    ,$
TYPE=ACROSSTITLE,JUSTIFY=CENTER                             ,$
TYPE=ACROSS     ,JUSTIFY=CENTER                             ,$
TYPE=SUBTOTAL   ,STYLE=BOLD  ,BACKCOLOR=RGB(210 210 210)    ,$
TYPE=DATA       ,TOPGAP=2    ,BOTTOMGAP=2                   ,$
TYPE=DATA       ,BACKCOLOR=(RGB(255 255 255) RGB(245 245 245)),$
ENDSTYLE
END