Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter property
Message
From
24/10/2008 02:17:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01356795
Message ID:
01356818
Views:
15
>I have created 2 reports that work great, except I have entered
> "LEN(ALLTRIM(Seeking)) > 0"
>in the datasession filter property.
>
>This gives the results I want in the reports, but after the reports have run, the filter is not reset. I tried putting a "SET FILTER TO" in the destroy property, but no luck.
>
>How do I release the filter?
>
>TIA
>Bill Broyles

Simply you don't put a filter there nor use dataenvironment of report's dataenvironment. Instead you do a select prior to reporting and get the records you want to report on into a cursor and run your report (report fields do not have aliases for the most flexibility except any related tables' fields if any).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform