IIf statement!?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » IIf statement!?

IIf statement!?

Rate Topic

Display Mode

Topic Options

Author

Message

davdam8

Posted Monday, September 10, 2012 7:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 156, Visits: 567

Hi people.

I need to customize a textbox on my report:
if the field value = 'True' then write 'Allowed'

How do I write this IIf statement?

Thanks
Regards

Post #1356744

H4K

Posted Tuesday, September 11, 2012 3:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

You can try following :

1)Go to properties section of the textbox by selecting the textbox and pressing F4.
2) Go to the Format section in properties.
3) Click the drop down near the Format section and select Expression.
4) Type the following expression in the expression window:

=iif(value = 'True', "Allowed", "Not Allowed")

Here 'value' is the textbox value at runtime.

BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI

Post #1357235

davdam8

Posted Tuesday, September 11, 2012 3:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 156, Visits: 567

Thanks. Works perfectly!
Regards

Post #1357240

« Prev Topic | Next Topic »

Permissions