Hi,

Just go by OOPs.

You can put this in the INIT of the form.

Thisform.dataenvironment.cursor1.Filter = < Filter Condition >

Bye
Jayesh

>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