On Fri, 2006-02-24 at 08:56 -0500, Bob wrote: > I've linked to a MySQL database using OO version 2 and created a report. > I'm trying to limit the data displayed in the report to essentially a > "like" SQL statement so that the only data displaying in the report > would be where "media" is like "DVD." > > The problem I'm having is not with the SQL statement - it's with the > report itself. > > I can't find any way to insert a "filter" in the report through the > various menu options when creating with the Wizard or when editing the > created form, and the OO (ver. 2) Help isn't of any assistance (at least > I couldn't find anything under "report" or "filter").
Open the report for editing, open the Form navigator window, under Form "ReportSource" select the "Command" control. Right-click and choose properties. Edit the SQL command in the value field to add a WHERE clause to the SELECT statement. It seems to work. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
