Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread DBISAM filtering - Infopower and Report Builder
Tue, Aug 28 2007 1:36 AMPermanent Link

"John Postnikoff"
I am using D7 with Report Builder and Infopower. I seem to have lost my
ability
to filter reports with any field in a DBISAM local application. Oddly the
data appears to filter the dataset on the grid I have , however the report
returns all records even after the filter component is executed.  .I thought
the problem was related to a time stamp field at first.  The problems
appears the same with any field I try to filter.

I use events such as Filterdialog.clearfilter or FilterDialog.applyfilter.

My code and properties appear to be the same before my conversion and RB
reports work with other DBISAM applications. Does anyone have any tips to
point me in the right directions?  Are there any limits. I cannot seem to
see it after a long day.

Tue, Aug 28 2007 1:48 AMPermanent Link

"Adam H."
Hi John,

When infopower creates the filter, how exactily are you using it? (ie, does
it modify the SQL, or does it populate the TDataset.Filter property)?

Also, is your dataset a TDBISamtable, or TDBISamQueries?

At a wild guess, try chaging the OpenDataSource and CloseDataSource
properties on the TppDBPipeline component both to false. Maybe reportbuilder
is closing and reopening the dataset, thus resetting the filter that
Infopower is doing?

HTH

Adam.

Tue, Aug 28 2007 11:38 AMPermanent Link

"David Farrell-Garcia"
John Postnikoff wrote:

> I am using D7 with Report Builder and Infopower. I seem to have lost
> my ability
> to filter reports with any field in a DBISAM

I use InfoPower filter dialog in my application. No problems at all.
Make sure you have FilterMethod property set to byFilter rather then
byQuery or you will indeed be changing the sql rather then just
filtering.



--
David Farrell-Garcia
Whidbey Island Software, LLC
Thu, Aug 30 2007 12:55 AMPermanent Link

"John Postnikoff"
It seems my filtering on my client server application of Timestamp fields is
the problem. For some reason it works in applications over local mode but
not over a WAN.

I do have my FilterMethod byFilter  property set as suggested. Perhaps I
need some other sort of syntax for the Infopower search.. I get an error
when I try to use the calendar and like options. Date fields seems to work
OK.

I am wondering if I have the syntax correct. Ca you give an example. I tried
to use mm/dd/yyyy hh:mm:ss

John

"David Farrell-Garcia" <davidF@NoStinkingSpamWhidbeyIslandSoftware.com>
wrote in message
news:F1506C1B-4C1D-4C34-B590-20E65D8875B2@news.elevatesoft.com...
> John Postnikoff wrote:
>
> > I am using D7 with Report Builder and Infopower. I seem to have lost
> > my ability
> > to filter reports with any field in a DBISAM
>
> I use InfoPower filter dialog in my application. No problems at all.
> Make sure you have FilterMethod property set to byFilter rather then
> byQuery or you will indeed be changing the sql rather then just
> filtering.
>
>
>
> --
> David Farrell-Garcia
> Whidbey Island Software, LLC


Thu, Aug 30 2007 9:49 AMPermanent Link

Chris Erdal
"John Postnikoff" <postnikoff@hotmail.com> wrote in
news:688C64AD-9029-4AD3-BF1E-B8BBE4FCFF61@news.elevatesoft.com:

> I am wondering if I have the syntax correct. Ca you give an example. I
> tried to use mm/dd/yyyy hh:mm:ss
>

have you tried yyyy-mm-dd hh:mm:ss ?

--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 4 + EDB 1.04 build 3)

Image