Solved

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

Posted on 2012-12-20
3
196 Views
Last Modified: 2013-01-02
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
0
Comment
Question by:BKennedy2008
3 Comments
 

Author Comment

by:BKennedy2008
ID: 38709738
Oh and Code is grouped together daily.
0
 
LVL 18

Expert Comment

by:vasto
ID: 38710180
Looks like a simple cross-tab. Did you try to create one ?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 38710667
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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now