I have a SQL Command Query, it has a Parameter that is listed in its where clause.

The actual Parameter is then filled dynamically through another SQL Command Query.

Everything works fine until I do the following.


I created a Formula Field.

IF {Command_2.COMPANY_ID} = {?Customer} THEN {Command_2.COMPANYNAME} ELSE ""

So ?CustomerID is correct when i place it onto the report the number that it is assigned works great.

the actual formula field returns the correct value but for some odd reason always there is a blank record when I right click on the formula field and go to browse data.

There are no nulls being passed, no multiple values from ?Customer.