Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summary is counting records that are not in report

Status
Not open for further replies.

Genepoz

Technical User
Aug 7, 2001
38
US
My report is grouped by distinct (no duplicates) alphanumeric Supply Codes from Table A. Those records are only selected if they match a Supply Code in Table B, in which there are duplicate Supply Codes. My report correctly shows only 1 instance of each Supply Code (there are no suppressed/hidden fields), but when I do a Count(Table A.Supply Codes) it counts the instances in Table B.
Table linkage is Table A.SupplyCode Left-outer-joined to Table B.SupplyCode.
Any ideas?
 
what is the formula you are using and what version of Cystal?
 
Sorry: Version 8. The record selection formula is
Table A.Supply Code = Table B.Supply Code
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top