Ok, need some help here. I have a report that pulls a field called "table.COSTCATID" containing individual names associated with a particular project. One of our projects, however, has multiple COSTCATIDs for each person, so each employee has many IDs with a number at the end (e.g. Name 55, Name 56, etc.). I only need to pull
one ID for each person b/c the salary, bill rate, etc is the same for each ID, unless a change is made on an indivual basis, which would be reflected in a
new COSTCATID.
So here's my dilema... currently, to avoid having unnecessary IDs pulling in the report, Report Select Expert is set up to have the COSTCATID field as "not one of"... and I list all the extras. Obviously, this is tedious each time new IDs are added.
Is there a way to tell crystal to just pull the highest unique value of those field lines? I tried a maximum formula, but that just returned the single highest ID (such as Name 55) for each line item instead of everyone's highest value (such as Doe 17, Smith 3, Last 82, Name 55).
How can I get it to pull the highest unique value for each ID in that field?
*FWIW - the field is a text string field.
Edited by analyst12150 - 06 Nov 2012 at 5:14am
IP Logged
