TonyE
|
| Posted: 08/27/2002, 6:12 PM |
|
I have a grid with events and I would like to filter it so it will only show future events. In the query builder, what is the parameter that I need to use, in the Where clause for the parameter source.
Or what is the easiest way to implement this?
|
|
|
 |
Nicole
|
| Posted: 08/28/2002, 7:03 AM |
|
Tony,
You should display the records where date is greater then current one. Create sql and test it against db you’re using. Once the test is successful you need to use only Where clause on CCS form. Open 'Data Source' dialog and add new parameter. In 'Table parameter' dialog set 'Condition Type' TO "Expression" and enter 'where' condition.
|
|
|
|
|
