Subject | RE: [IBO] TIBOTable and QR |
---|---|
Author | Leigh J. Worthing |
Post date | 2001-10-31T17:19:52Z |
I use two TBOQuery's to give a Master-Detail relation to print with QR
Leigh
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Andy
Murphy
Sent: Wednesday, October 31, 2001 8:59 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] TIBOTable and QR
No I dont think it works, you see when you link a query as the master to the
table (detail) then the table automaticcally populates when the master
record changes. A function I'm told QR requires, otherwise the param would
have to be refreshed for every new generated page in the report.
Imagine this, the user selects 10 Master records from my existing TIBOQuery,
each of these has say 10 records of detail in the TIBOTable.
You set the QR detail band to use the TIBOQuery and drop a sub-detail band
on the QR and tell that to use the TIBOTable. Once you have told the
TIBOTable that its master source is the TIBOQuery and its MasterFields is
the connecting field, QR sorts it all out from there. You get a 10 page
printout with independent master information on each page and then a nice
list of 10 detail items on that page.
I have no idea what would trigger an TIBOQuery if I was to use it to change
the param on every new QR page when the master changes.
I do agree though that my select would be easier as I could specify an
order.
This might not sound that important,, but placing an index on that many
records produces about 100mb and I'll have to send all our clients out a new
disk, which I'm trying to avoid doing.
Thanks,
Andy
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Leigh
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Andy
Murphy
Sent: Wednesday, October 31, 2001 8:59 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] TIBOTable and QR
No I dont think it works, you see when you link a query as the master to the
table (detail) then the table automaticcally populates when the master
record changes. A function I'm told QR requires, otherwise the param would
have to be refreshed for every new generated page in the report.
Imagine this, the user selects 10 Master records from my existing TIBOQuery,
each of these has say 10 records of detail in the TIBOTable.
You set the QR detail band to use the TIBOQuery and drop a sub-detail band
on the QR and tell that to use the TIBOTable. Once you have told the
TIBOTable that its master source is the TIBOQuery and its MasterFields is
the connecting field, QR sorts it all out from there. You get a 10 page
printout with independent master information on each page and then a nice
list of 10 detail items on that page.
I have no idea what would trigger an TIBOQuery if I was to use it to change
the param on every new QR page when the master changes.
I do agree though that my select would be easier as I could specify an
order.
This might not sound that important,, but placing an index on that many
records produces about 100mb and I'll have to send all our clients out a new
disk, which I'm trying to avoid doing.
Thanks,
Andy
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/