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.
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.
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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.