Return all Values in a Paramater field

[f0rg3tfu1]

Hello all,

CR 10, SQL server 2000 backend

I am using a parameter field to select a building number to return all the inventory from that particular building.

We have 24 buildings... and I would like to add a choice of "All" in the parameter field to select all buildings.

I remember doing this before, but I cant remember how. Feel free to post if you need more information, but I think this is enough.

Thanks a lot everyone!

 

[MrBillSC]

In your parameter field enter "All" as the top default value.
In your record selection formula enter:
({?Building} = "All" or
{?Building} = {table.buildingfield})
MrBill

 

[f0rg3tfu1]

Thank you Mr. Bill... PERFECT!