Subject Re: [IBO] Re: IBO & Report Builder Woes
Author Helen Borrie
Go to http://www.egroups.com/files/ibobjects and download them.

Helen


At 10:19 PM 14-12-00 +0000, you wrote:
>How do I get the latest version?
>
>Steven
>
>--- In IBObjects@egroups.com, "John Tomaselli" <jrt@g...> wrote:
> > Steve,
> > I have used the latest of IBO/RB for sometime now and have what I
>consider
> > the best of breed products. One thing I have done is to put as many
>of the
> > calculations in the query (using the oncalculcateField event with
>ib_query
> > and ibo_pipeline (get the latest version which I sent to Geoff W about 2
> > weeks ago). I think this will provide much greater flexibility and
>speed.
> > John
> >
> >
> > -----Original Message-----
> > From: Steven Gibb [mailto:sgibb@n...]
> > Sent: Thursday, December 14, 2000 1:56 PM
> > To: IBObjects@egroups.com
> > Subject: [IBO] IBO & Report Builder Woes
> >
> >
> > I am doing further development for a fairly large Delphi BDE app using
> > Interbase that contained about 40 standard reports built by using Report
> > Builder. Some of these reports are complex using a lot of calculated
> > variables, others are simple.
> >
> > I am using Report Builder 5 Enterprise, Delphi 5 Enterprise and IBO
>3.6Ca.
> > For some reason some of my existing reports do not generate
>correctly with
> > Report Builder 5.5 so I have not upgraded
> >
> > I have converted the app to using IBO instead of the BDE. Most of the
> > conversion seemed to be fairly straightforward and did not pose a lot of
> > problems to get things running. Converting the reports section of the
> > application has been more difficult and let to problems. I converted my
> > TwwQuery components to TwwIBOQuery. At this point I was using the
> > TppBDEPipeline, however the reports did compile and run. Some of the
> > reports ran a little faster with IBO than they did using BDE access
>to the
> > Interbase database. However a few of the reports would run correctly but
> > they ran much slower using IBO. For example one report takes about 2
> > seconds to generate and display in the BDE version and over a minute
>in the
> > IBO version. Not likely to impress the customer!!
> >
> > I tried using the TppIBOPipeline (distributed with IBO) but it did
>affect
> > performance in the problem reports. One of the problem reports uses the
> > query FilterRecord event so I can't convert it to TIB_Query, however in
> > some reports I tried using TIB_Query instead of TwwIBOQuery but it
>did not
> > improve performance.
> >
> > The only thing that seems to be different in the reports that run much
> > slower in the IBO version is that these reports tend to have a lot
> > calculated variables on the report.
> >
> > Can anyone suggest what might be causing this problem? The BDE
>version and
> > IBO version of the reports are identical except for the component
> > replacements.
> >
> > If I could find a solution for these few problem reports, I would
>consider
> > the conversion from BDE access to IBO access a complete success.
> >
> > Steven Gibb
>
>
>

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________