Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

How do I Alternate font color as account # changes in group with suppression

My report compares records comprised of 5 fields from 2 systems and prints a record when the records do not match. In my printing group I suppress those records that match. Often times I will print more than one record with the same account number. I need to alternate font color when the account number changes.  
I have tried a few options that were posted. One prints alternating color (does not take into consideration the account)
Shared NumberVar gr_cnt;
if ({#Record Count}) <> 0 then
gr_cnt := gr_cnt + 1;
if gr_cnt  mod 2 = 0 then
  crNoColor
else
 Crsilver

So I tried a running total that changes only when the account changes & using the above formula, but I get a Print time formula error because I am using the Next funtion. Anyone have an idea? Thanks in advance.
0
Goosie1
Asked:
Goosie1
  • 2
  • 2
1 Solution
 
mlmccCommented:
I am not clear on what you are trying to do.

You want to change the color when the account changes
FontCOlor - Normal
Account 1234
Record1
Record2
FontColor - crSilver
Account 1235
Record1
Record2
etc

I assume you have the records grouped by account number
Simply update your count in the group header formula that sets the font color  I dont see the NEXT function being used.

Did you setup your running total to evaluate On Change of Account Group?

mlmcc


0
 
Goosie1Author Commented:
Sorry I will try to be more clear.
Group 1 Account - suppressed
Group 2 Service Code- suppressed
Group 3 Date- suppressed
Group 4 Formula which concatenates Account+Service Code+Date - Supress if the concatenated string matches

So I may have 5 records for account 123, but in group 4 Only 3 of them will display because they do not match.
To print I want to see Nocolor:
Account 123 Code A Date 1/1/11
Account 123 Code A Date 1/2/11
Account 123 Code B Date 1/1/11
Then the next account records that don't match would print CRSilver

I tried to use the Next function in a formula in Group 4:
@Account Count:
If Account= next(Account)then 0 else 1)
Then in the Group 4 Color(Note #Record Count is my suppression criteria):
Shared NumberVar gr_cnt;
if ({#Record Count}) <> 0 and {@Account count} = 0
then
gr_cnt := gr_cnt + 1;
if gr_cnt  mod 2 = 0 then
  crsilver
else
  crnocolor

This works for some records, but not all.
0
 
mlmccCommented:
WHy not use the group select expert to eliminate the groups with more than 1 record.

Count({@Group4}) = 1

mlmcc
0
 
Goosie1Author Commented:
You rock!
I hadn't thought of that!  I removed extra groups then added the count of Group 4 = 1 which cleaned up the data so much. Now it is running perfectly.
Thanks so much!
Michelle
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now