Exaggerated Total

[fsub]

Hi..

In CR8.5, how do you avoid a cartesian product? I have 2 tables. Amounts on tableA are totaled and so are amounts in tableB. Total of TableA is exaggerated.

Thanks

 

[kray4660]

How are the tables joined?

 

[fsub]

These are MS-Access tables with an equal join. Join type is grayed out so I cannot really experiment with different joins.

 

[kray4660]

In that case, if you can (allowed to). Create a query in Access with the two tables joined, then create a report using the query as a data source. I believe you find it works better.

I hope this helps.

 

[fsub]

Thanks Kray. Creating a query was an attractive solution. I tried it but my query resulted in duplicate records. These tables are laid out differently with a few common fields.

 

[kray4660]

Are the entire rows duplicated? If so you should be able go to Database, Select Distinct Records. If the row is not totally duplicated. Then you may need to do some grouping and hide the details. Without knowing the database, it can take some time.

I hope this helps.

 

[fsub]

Yes, the entire row is duplicated. Unfortunately, the 'Select Distinct Records' is grayed out in both Database menu and Report Options. I am looking at grouping now.

 

[fsub]

I formulated and grouped by a RecordID. It worked well. Thanks for the tip.