Avatar of BKennedy2008
BKennedy2008
 asked on

quick 500pts...Crystal report count an item in details

So I have a CR that shows in the details pane:

Day 1  Item code                
            AU
            CN
Day 2
           AN
           AU
           CN
Day 3.......

I need to produce this summary:

Code          Days in Service
AU               2
CN               2
AN               1
             

I would imagine it is a formula My brain is not functioning right now...
T
Crystal ReportsVisual Basic.NET

Avatar of undefined
Last Comment
Mike McCracken

8/22/2022 - Mon
BKennedy2008

ASKER
Oh and Code is grouped together daily.
vasto

Looks like a simple cross-tab. Did you try to create one ?
ASKER CERTIFIED SOLUTION
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61