Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A form that set filter to a report.
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00387726
Message ID:
00387809
Views:
23
>Epale pana,
Ejele!!!

>
>You could clear the filter in your form's init event or perhaps right before the form sets the new filter.

I create the filter from within a button's click event, something like this:

myfilter=".t."
if thisform.check1.value=1
myfilter=myfilter+" and myfileld>0"
endif

if thisform.check1.value=1
myfilter=myfilter+" and !empty(myotherfileld)"
endif

if !empty(thisform.text1.value)
myfilter=myfilter+" and myanotherfield="+thisform.text1.value
endif

..etc

myfilter="report form myreport for "+myfilter+" preview"
&myfilter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform