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:
00387812
Views:
10
Eh!

I thought you were explicitly setting up a filter condition with "set filter to...".

Looks like you're probably better off going the cursor route (as I think Mike suggested).

Suerte,

Alex

>>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
Low-carb diet not working? Try the Low-food diet instead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform