so, in my report i'm initializing variables in the header, setting the variables in the output (supressed) and then calling the variable in the footer as to get one single line with all of my data for each employee.

I've got several formulas that look at one field that has many results and it's shows a true or false depending upon the data in the field. when i run the report it's returning all false however if i look at the raw data in sql i can see that several should be true.

i'm not quite sure what's happening.

any thoughts?

i tried that and then it just shows me several records for the first field only (emp id) and then shows me the footer. it's weird i'm not sure what is bunking out on this report. 

here is the formula

If {ETax.tcode} In ["MED", "SS"]
    Then "Y"
Else
    If NOT ({ETax.tcode} In ["MED", "SS"])
        Then "N"

super simple

in the footer it shows N,N,N,N,N

when in fact it should be N,Y,N,N,Y

if i look at each individual line it would look like

N N N Y N
Y N N N N
N Y N N N
N Y N N N

i thought maybe the variable was resetting too soon so i tried it without it and still got the same results.

in the footer i'm calling the variables like

var1 + "," + var2 "," and so on

Thanks DBlank! for some reason still no luck. I'll do some more digging tomorrow.