Hi Bill,
Set Filter is probably not the best solution for such a problem. It could really slow things down. I would rather, create an SQL at run-time and execute it to retrive the records depending on various parameters(filter conditions) defined by user.
>Is there anyway to set the filter on a view opened in the report.DataEnvironment at runtime ?
>
>I've tried setting the Cursor.Filter property in the BeforeOpenTablesEvent, but it doesn't work.
>
>Ideally, I would like to set a global variable to a filter expression and have the report set the filter for the view as it starts up.
>
>An example:
>I have a view that has every invoice in it. Sometimes I want to print all outstanding invoices, sometimes I want to print just one invoice, sometimes I want to print all invoices with duedates in the next week, etc.
>I would like to have the view just trade out the filter for the report.
>
>TIA