ReportServer Forum

akamatch14

Member

Registered: Yesterday

Issue with Report Column Display

I need help with a column in my report. When I run the report, one of the columns displays "False" instead of "No." Can someone assist me in updating this column so that it shows "No" instead of "False"?

Thank you!

alex_lust

Moderator

Registered: 2020-07-03

Website

Re: Issue with Report Column Display

Hi akamatch14,

You can fix the “False”/“No” display in two ways:
1.    Computed Field. In ReportServer, create a computed field that returns “No” instead of “False.” Check the documentation or this forum post for details:
o    https://reportserver.net/de/guides/conf … -Lists.php
o    https://forum.reportserver.net/viewtopic.php?id=301

2.    SQL Query
in the query directly, use a CASE (or similar function) to replace “False” with “No.”

Is this a dynamic list report? That will determine the best approach.

Best regards,

Alexander

alex_lust

Moderator

Registered: 2020-07-03

Website

Re: Issue with Report Column Display

more usefull: https://reportserver.net/en/guides/user … ed-Columns

akamatch14

Member

Registered: Yesterday

Re: Issue with Report Column Display

Thank you Alex! Adding the the CASE directly in the SQL query worked.

Cheers,
Chris