Hoe Can I Change Report Field Value

[belkin_99]

Hi,
I created a query that return back values into the report. one of these values is gender and it is come (1 or 2).
How can make the report display M instead of 1 and Female instead of 2.
Where i used in the field proerty =IIF([fieldname]=1,"M","F")
but it did not work and i dont now Why?
any help will be greate?

[Island1]

Hi:

There are several ways to do this, particularly via the underlying query, etc. Could you please let us know what reporting app we're talking about? Also, a little information about the data source (MSSQL Server 2000, 2005, OLAP cube, etc.) would also likely enable a better response.

Thanks!

Bill

[belkin_99]

Thanks For your help,
I fixed this problem by using CASE statment on the SQL Procedures.

[Island1]

Glad you got it "fixed."

And thanks for posting us on your successes!

Bill