Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 5 of 5 total |
DBISAM filtering - Infopower and Report Builder |
Tue, Aug 28 2007 1:36 AM | Permanent 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 AM | Permanent 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 AM | Permanent 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 AM | Permanent 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 AM | Permanent 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) |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |