Report1.filter Problem

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
auspac
Posts: 19
Joined: Tue Oct 10, 2017 12:44 pm

Report1.filter Problem

Post by auspac » Wed Jul 20, 2005 6:14 am

I am using Reports (Latest Version)and Visual Basic 6 and have a report printing ok.__BUT...__I am attemping to override the filter in the report created using..__Report1.filter = "Id <= 2" (id is an vb6 table autonumber field i have used to simplifythe question)____This command does not have any effect on the report.ie the filter does not seem to override.____ WDir = "c: rordersuntitled.rsw"__ Report1.ReportName = WDir__ Report1.filter = "Id <= 2"__ Report1.Destination = 1__ Report1.Action = 1__I notice when i type in report1.Filter it changes it to lowercase__.filter., may not mean anything!!____Appreciate some help as to how to get this to work.____In addition i will need... to set a filter to say__forego.clienta >= "AAAAAA" AND FOREGO.GROUP = 6 AND FOREGO.FEATURE >= "DDDDDD"__Appreciate the string eg Report1.Filter = ????________

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Report1.filter Problem

Post by kfleming » Thu Jul 21, 2005 8:15 am

You need to add an include=2 to get the filter to override the saved filter.____ WDir = "c: rordersuntitled.rsw" __ Report1.ReportName = WDir __ Report1.Include = 2 __ Report1.filter = "Id <= 2" __ Report1.Destination = 1 __ Report1.Action = 1 ______Kathleen__R&R Support

auspac
Posts: 19
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Report1.filter Problem

Post by auspac » Thu Jul 21, 2005 4:52 pm

Kathleen,__Thanks for the help__Regards Karen

Post Reply