jenfromjax
Technical User
I am using Crystal Reports v10 accessing a SQL Server (v8 I think).
SCENARIO:
I have a Salesmen Commission Report. The report is grouped 1st by "Region", then by Salesman ("Rep"). This order of grouping is not negotiable unfortunately.
Occasionally, a Rep will sell something in more than one Region. Usually because the Regions get reassigned throughout the year.
I need all occurrences of the "Rep" ({table.rep}) field to turn red if there is more than one occurrence of a Rep in the report.
EX:
Region 1
Rep Sale Quota
John Doe $5,000 5,000,000
Jane Doe $6,000 5,000,000
Joe Smith $3,000 5,000,000
Region 2
Rep Sale Quota
Mark Jones $4,000 8,000,000
John Doe $2,000 5,000,000
Jen Walker $1,000 8,000,000
QUESTION:
I know how to apply conditional formatting, like mentioned above. However, I do not know how to get the number of occurrences of a Rep and then use it as the conditional formatting criteria.
I would appreciate any advice!! Please let me know if you need more info. I tried to cover everything.
~Jen
SCENARIO:
I have a Salesmen Commission Report. The report is grouped 1st by "Region", then by Salesman ("Rep"). This order of grouping is not negotiable unfortunately.
Occasionally, a Rep will sell something in more than one Region. Usually because the Regions get reassigned throughout the year.
I need all occurrences of the "Rep" ({table.rep}) field to turn red if there is more than one occurrence of a Rep in the report.
EX:
Region 1
Rep Sale Quota
John Doe $5,000 5,000,000
Jane Doe $6,000 5,000,000
Joe Smith $3,000 5,000,000
Region 2
Rep Sale Quota
Mark Jones $4,000 8,000,000
John Doe $2,000 5,000,000
Jen Walker $1,000 8,000,000
QUESTION:
I know how to apply conditional formatting, like mentioned above. However, I do not know how to get the number of occurrences of a Rep and then use it as the conditional formatting criteria.
I would appreciate any advice!! Please let me know if you need more info. I tried to cover everything.
~Jen