Liveware Publishing Support Forum

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 = ????________

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

Kathleen,__Thanks for the help__Regards Karen