SSRS if string says this then change it to this

visual-studio reportingservices-2005 reporting-services
user380432 picture user380432 · Aug 25, 2010 · Viewed 10k times · Source

I have a field in SSRS and it returns from SQL saying "Incomplete"

In SSRS I want to say anytime this field says "Incomplete" to change the string to "Pending"

This has to be done in SSRS.

Thanks!

Answer

Decker97 picture Decker97 · Aug 25, 2010

Just use an expression:

=iif(Fields!Field1.Value="Incomplete", "Pending", Fields!Field1.Value)

Related questions

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

I get the following error when trying to connect to SQL Server: Cannot connect to 108.163.224.173. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the …

Read More
How do you auto format code in Visual Studio?

I know Visual Studio can auto format to make my methods and loops indented properly, but I cannot find the setting.

Read More
How do I remedy "The breakpoint will not currently be hit. No symbols have been loaded for this document." warning?

A C# desktop application on the express edition worked, but then it didn't work 5 seconds later. I tried the following: Ensure debug configuration, debug flag, and full debug information are set on all assemblies. Delete all bin and obj folders …

Read More