Since it appears that absolutely nobody from Component One reads or respondsto this Newsgroup, I'll go ahead and respond to your question...but I'm justanother customer trying to get help with this otherwise excellent product.

If I understand your question correctly, there are a couple of differentways of applying "filters" at runtime.

You can set the RecordSource property to a SQL SELECT statement todynamically build the source for the report...you must do this in the OnOpenevent.

Or, if your recordsource includes a WHERE clause that expects a parameter,such as in WHERE Customer = ?, then you can set the value of that prompt byusing the QueryParamVal collection like this:

vsreport1.QueryParamVal(1) = "whatever"

You can pass in as many prompts as you need, but I find it easier to buildmy SQL within my code and simply set the RecordSource property...probablysome performance improvements that way as well.

wrote in message news:3a9b52fb@news.apexsc.com...> Hi, how do I apply a filter at run time?