Hi,

Not  sure if the title really desc. what I need..
But here it goes..
I have a report the groups on name then location.
a name can have up to 4 locations
i hvae a counter on location
so I have abc  counter =1
                def  counter=2 etc...
at the break of client
I want to display up to 4 locations

client1  - abd,def
client2  - abc,def,ghi
client3  - abc,ghi
client4 - abc,def,ghi,jkl 

Does this make any sense??

Thanks
Joe

Sorry ,

I'm just getting back to this..
Sorry I'm a bit confused...
I have string variables:
ABC
DEF
GHI
JKL

each one moves an 'X" to  them if it meets a critera...


a client can have from 1 to all 4
at the end I want to have a count of who has only 1
who has two,
3 and
4 ...
                                name            abc  def  ghi   jkl
details looks like ...  jim                  X            X     X
                                Joe                        X      X      

Footer looks like
21 have only 1
32 have 2
etc

Thanks
Again



Edited by jbalbo - 29 Nov 2012 at 11:42am

Thanks for getting bacj..

My fault..
Im horrid at explaining..

Abc..def... etc are running totals created via a formula
what I do as unconventional as it sounds.. I use a formula with the letter X in it then in the running total if a value meets a criteria it puts the X in the running total

Not sure how to set up the shared variables as u explained?

Thanks Again

I think this will work but do I setup as seperate formulas?

Thanks