Hi Folks,

I have seen a couple demos, but don't know how to do it.

I have a report need to be group by Company or Division, so I want to create a variable, let user pick Company or Division at runtime.

How I can create a procedure with such a variable?

Thanks.

George,

Create your fex with a variable called SELBY and make it your BY.

TABLE FILE CAR
PRINT
CAR
BY &SELBY
END

Then create a html page with a drop down list and map the parameter SELBY to it. As long as your drop list has values that are field names then it will work.

Fernando

Thanks for your reply.

When I go back to Developer Studio, is there a way I can modify this variable, so user will:

1) See a drop down list box
2) In the drop down list box, there is only "CAR" and "COUNTRY"

Thank you again!

My question should be:

In Developer Studio, is there a GUI to help me to limit the fields I want my user to see?

Thanks.

The "Report Field Variable" (Right click in the Object Inspector) allows you to create a static list of choices.