How do I select conditions so I can create a job cost report for several cost codes without duplication for the second one (or other errors).
I am using Job Costs, Job Cost Detail Report which is a canned report from Report Designer. When I add conditions for two or more cost codes using 'and' and 'or', any cost code after the first will have all duplicate entries. If I run the report for them individually they are fine. If I reverse the order, again, the first one listed is fine the others all have duplicate entries.
I am using Job Costs, Job Cost Detail Report which is a canned report from Report Designer. When I add conditions for two or more cost codes using 'and' and 'or', any cost code after the first will have all duplicate entries. If I run the report for them individually they are fine. If I reverse the order, again, the first one listed is fine the others all have duplicate entries.
Sally, your issue is likely the result of adding conditions to those already included in the design, and mixing "and" and "or". You can't mix "and" with "or". You better solution would be to create a formula for your desired cost codes, using an "or" statement in that formula. Then add that formula as a condition using "and".
Art Minds
Senior Independent Consultant
Pasadena CA
*Community Hub is the new name for Sage City