Subject Re: [IBO] Master Detail Structure with IBOQery
Author stanw1950
Helen, I don't know about Carlos, but this technique solved one of my
problems of printing a report based on what's in a user defined
tib_grid. Thanks.

--- In IBObjects@y..., Helen Borrie <helebor@t...> wrote:
> I wrote:
> > > I like to create my datasets for QuickReport using TIB_Query
objects, then
> > > pass my data specs through to TIBOQuery objects using
> > > AssignSQLWithSearch(). That's because I prefer to work with
> > > IBO.
> At 11:02 AM 29-05-02 +0100, Carlos Macao wrote:
> >I use ReportBuilder instead with TIBOQuery, would you mind to
explain me
> >your aproach with a little more detail?
> Since I don't use RB, easier would be for you to try it out for
> For my QuickRep, I have TIBO* queries for each datastructure I need
for a
> report. Whilst I'm designing the report, I have "stub sql" in
> queries - just sufficient to supply a data template that matches
> structure of the dataset which will be used in the real report,
without any
> selection criteria; or with some "typical" selection criteria.
> These queries are hooked up to my IB_Connection via their Database
> property. Often, I will give them their own transaction, too,
since I
> usually want tiConcurrency for reports, whereas the interactive
work runs
> in tiReadCommitted.
> I'll then write a procedure that does any "business" required
around the
> native dataset, then assigns the latest dataset to the IBOQuery or
> IBOQueries that are providing the data for the report, typically:
> if Mode = 'Report' then
> with ReportData do // ReportData is my IBOQuery
> begin
> if Active then Close;
> if Prepared then Unprepare;
> InternalDataset.AssignSQLWithSearch(IB_Query1);
> Prepare;
> Open;
> end;
> end;
> After that, I just create the QuickRep object, run the report
> Preview, etc.), destroy that and then (if needed) commit the
> and close the datasets.
> At one time, before I had tried it, I thought it seemed very
complicated to
> do. As it turned out, it was not complicated at all - it works
exactly as
> I want it to. You can do just about anything you want with your
> (native IBO-based) dataset and simply capture its latest SQL specs
and pass
> them over to your report.
> regards,
> Helen Borrie (TeamIBO Support)
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at