selecting all in a dialog box

[strawberry]

Hi, i have a report which works from the underlying query like this

it asks for start date and end date or blank for all (this works fine)

then it asks for status of quotation, ie live, dead or order or blank for all (this works fine)

the final part brings up a dialog box for the operator to choose from, it lists all the products from the product table and then they choose one and the report is then created based on this criteria

How can i change the last part so that the operator can choose one OR ALL PRODUCTS.

Because the operator is choosing from the list of products(which is an actual table) i dont see how i can do this

Many thanks

Hope you can help

 

[rsmonkey]

a few ways of doing this, but you should simply add 'All Products' to your dropdown. When the user selects 'All products' this would then initiate a simple If statement and executing the necessary SQL / Query statements.. job done

 

[strawberry]

thank you very much for your reply

where would i put the code, in the query, or behind the product 'form' that is being used as the dialog box

Many thanks