Report Builder 6 & TIBQuery

rbuser

Hi and thanks for any help you can provide.

I've got Report Builder Pro v6.01 installed on Delphi 5. I'm trying to
use a TIBQuery, A TDataSource, and a TDBPipeline to build a summary report
(using a "group by" in the SQL query). For some reason the report has the
correct number of rows, but the data is always the last two rows repeated,
i.e.:

The report should be (running the SQL directly in the Interbase ISql query
app):

Category Count $
1 2 $100
2 3 $ 99
3 1 $ 25
4 2 $ 10

But when I test it in report builder I get:

Category Count $
3 1 $ 25
4 2 $ 10
3 1 $ 25
4 2 $ 10

This report runs fine if I use a TQuery (instead of a TIBQuery), or if I
don't use a Group By statement, all rows show. I'm at a loss and couldn't
find anything on the Internet. Is there a way to correct this or is this
version of report builder simply not compatible with TIBQuery?

Thanks a lot.

Doug



--- posted by geoForum on http://delphi.newswhat.com

rbuser

I was able to fix my problem by recreating the Query, Datasource, Pipeline
and Report completely from scratch. Not sure what happened.

Doug



--- posted by geoForum on http://delphi.newswhat.com