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
Bill Morris