CODEWITHSUNDEEP
sqlreporting-serviceslabel
user3569565
user3569565

Reputation: 1

SSRS Data Labels within created tables/graphs

The SQL database holds gender as 1 and 0 and obviously when I generate a report in SSRS Gender is labelled 1 or 0 in the table/graph.

I would like it to show Male or Female. Can this be done within SSRS?

Or is it best to change the data in the database.

Thank you

Upvotes: 0

Views: 122

Answers (1)

Ian Preston
Ian Preston

Reputation: 39566

Instead of referencing the field directly, you can use an IIf expression like:

=IIf(Fields!gender.Value = 1, "Male", "Female")

It might be useful to look at Expression Examples (Report Builder and SSRS).

Upvotes: 3

Related Questions