Skip to Content
Former Member
Oct 06, 2014 at 01:57 PM

Creating scrap report for MISys


I would like to organize scrapped kit components in order by the item number that way they are all grouped together. I attached a pdf of the scrap report I would like to modify and the associated rpt as a pdf since I couldn't attach a .rpt and .xml. Is there a formula or command that will group all the item numbers in order? For example in the item number column FGAA-100, FGAA-100, FGAA-100, FGAA-101, FGAV-100, INVV-080, BLANK.... Then after each grouping, I would like for there to be a total count of only that item number's scrap quantity. So FGAA-100 total scrap quantity = 120. Do the details and headers create the lines that will be used? I do appreciate all the help and I have not idea how to work crystal reports. Thank you!


scrap report.JPG (58.2 kB)