Print Page | Close Window

Details b repeating on details a

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22532
Printed Date: 06 May 2024 at 2:20pm


Topic: Details b repeating on details a
Posted By: Twizik
Subject: Details b repeating on details a
Date Posted: 29 Jan 2018 at 10:28am
Good afternoon all, I have an invoice report that is duplicating detail b lines on detail a when the report is run.

ItemType - 0 = Labor
ItemType - 1 = Parts
ItemType - 3 = Misc
There are no other ItemTypes

Details A - 
{WOITEMS.QCOVERED} = "Y";

{WOITEMS.ITEMTYPE} = 0;


https://imgur.com/giXucnO - https://imgur.com/giXucnO

Details B - 
{WOITEMS.QCOVERED} = "Y";

{WOITEMS.ITEMTYPE} = 1;

{WOITEMS.ITEMTYPE} = 3;


https://imgur.com/dfB5qeC - https://imgur.com/dfB5qeC

As you can see in this image there is a Labor line duplicated under Parts, this line should not be there. It seems like the suppress code for Detail B is ignoring the third line "{WOITEMS.ITEMTYPE} = 3;". I have tried Suppressing duplicates but it did not solve the issue. I can switch ItemType 1 and 3 and it will move the duplicated labor lines to the Misc section.

Crystal Reports Version 14.1.2.1121


Print Page | Close Window