| Computers Forum Index » Computer - Databases - Paradox » Filter reports... |
|
Page 1 of 1 |
|
| Author |
Message |
| Craig... |
 Posted: Sat Jun 20, 2009 5:27 pm |
|
|
|
Guest
|
I am sure this has been reported before, but can anyone point me to an easy
way to filter a report with opal?
Craig |
|
|
| Back to top |
|
|
|
| Liz McGuire... |
| Posted: Sat Jun 20, 2009 6:18 pm |
|
|
|
Guest
|
Using ObjectPAL to filter a report is harder, IMO, than using a query to
come up with the data you want in the report and basing the report off
an answer table (or twelve). Also, depending on the details, the filter
could be considerably slower.
But, see the report type variable in ObjectPAL help. I believe you'll
have to attach a UIObject var to an object on the report and then use
setGenFilter.
Liz
Craig wrote:
Quote: I am sure this has been reported before, but can anyone point me to an easy
way to filter a report with opal?
Craig
|
|
|
| Back to top |
|
|
|
| Steve Caple... |
| Posted: Sat Jun 20, 2009 9:28 pm |
|
|
|
Guest
|
On Sat, 20 Jun 2009 09:27:30 -0400, Craig wrote:
Quote: I am sure this has been reported before, but can anyone point me to an easy
way to filter a report with opal?
It's really better and ultiately more satidfacory to "filter" the data via
a query and report on the query answer. Ask if you need assistance
changing the report table (and look up data models and table aliases).
--
Steve |
|
|
| Back to top |
|
|
|
| Craig... |
| Posted: Sat Jun 20, 2009 10:13 pm |
|
|
|
Guest
|
Thanks Liz and Steve,
I can easily do the queries (the report will be multi-table. I was just
wondering if there was a trick that was easy. Eventually, the tables from
which the report will be drawn will be large, so doing the queries is
probably better.
Thanks again,
craig
"Steve Caple" <stevecaple at (no spam) commoncast.net> wrote in message
news:d8h4dv6q6zh1.1vrq26fu9kalj$.dlg at (no spam) 40tude.net...
Quote: On Sat, 20 Jun 2009 09:27:30 -0400, Craig wrote:
I am sure this has been reported before, but can anyone point me to an
easy
way to filter a report with opal?
It's really better and ultiately more satidfacory to "filter" the data via
a query and report on the query answer. Ask if you need assistance
changing the report table (and look up data models and table aliases).
--
Steve |
|
|
| Back to top |
|
|
|
|
