dbTalk Databases Forums  

Filter reports

comp.databases.paradox comp.databases.paradox


Discuss Filter reports in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Craig
 
Posts: n/a

Default Filter reports - 06-20-2009 , 09:27 AM






I am sure this has been reported before, but can anyone point me to an easy
way to filter a report with opal?
Craig

Reply With Quote
  #2  
Old   
Liz McGuire
 
Posts: n/a

Default Re: Filter reports - 06-20-2009 , 10:18 AM






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


Reply With Quote
  #3  
Old   
Steve Caple
 
Posts: n/a

Default Re: Filter reports - 06-20-2009 , 01:28 PM



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

Reply With Quote
  #4  
Old   
Craig
 
Posts: n/a

Default Re: Filter reports - 06-20-2009 , 02:13 PM



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) commoncast (DOT) net> wrote

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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.