Issue with Report Column Display

ReportServer (EN)
1

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!

2

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/config/chapters/Dynamic-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

3

more usefull: https://reportserver.net/en/guides/user/chapters/Dynamic-Lists.php#Computed-Columns

4

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

Cheers,
Chris