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

BKennedy2008
BKennedy2008 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
BKennedy2008

Author

Commented:
Oh and Code is grouped together daily.
vasto
Top Expert 2011

Commented:
Looks like a simple cross-tab. Did you try to create one ?
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
I agree this looks like a classic crosstab

What data do you have?

You cold try formulas like

If {Field} = 'AU' then
   1
Else
   0

You can then summarise it to get the days.

How many values are there?

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial