Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Cursor Filter
Message
From
30/07/1998 14:49:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Setting Cursor Filter
Miscellaneous
Thread ID:
00122805
Message ID:
00122805
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform