Cross Tab report problem

rbuser

Hi, I use the following

select SUBJECTID, ENTITYNO, WEIGHT from ASSESSWEIGHT
join SEMESTERPERIOD on (assessweight.periodno=semesterperiod.periodno)
where clabbreviation='4B1'

The result set contains contains 7 subjectid and 7 entityno which makes up
49 rows.

I configu the crosstab table as follow:
entityno
subjectid sum of weight

this makes up a 7 by 7 table.

The result table repeated 49 times!!!

I am using rb6.02, AstaClientDataset and TIBQuery.
All of them produe same result.

How to solve it?

Thanks
Marcel

digitalmetaphors

Disconnect the report form the datapipeline. Then reconnect the crosstab to
the datpipeine. The detail band will print for every record in the
datapipeline that the report is connected to. The crosstab will print once
per detail band traversal, which is why you get this behavior. You will
want only one detail band to print:)


Cheers,

Jim Bennett
Digital Metaphors