Please do *not* start a new question by replying to an old one as this
causes several problems:
1. most email software will correctly think that your email is a
response to the email you are "replying" to, and will indicate
this by displaying your email as a child of the original email
2. because of this, people not interested in the original email may
ignore your question
3. people may think that the original email has a reply(yours) so
that they do not have to give it a reply
So in conclusion, more people will read your email if it looks like the
start of a new thread rather than the reply to an old one.
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").
>
>
> How do I filter the data in a report to that which I want displayed?
>
As you do not seem to be subscribed, you may have missed the following
reply:
> On Fri, 2006-02-24 at 08:56 -0500, Bob wrote:
>
> 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.
>
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
