This is a migrated thread and some comments may be shown as answers.

Expression Help

1 Answer 33 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
John Downey
Top achievements
Rank 1
John Downey asked on 10 Dec 2009, 02:46 PM
I have this expression set to a textbox's value in a report:

(=IIf(Fields.Implemented = True, CStr(Completed), CStr(Not Completed) ))

This is showing up as text in my report as a string. I also tried putting the strings as 'Completed' rather than CStr(Completed) which also didn't work.

What I want is "Completed" to be displayed when Fields.Implemented resolves to true. "Not Completed" when Fields.Implemented resolves to false. Can someone help me form this expression? Thanks in advance to anyone who replies

1 Answer, 1 is accepted

Sort by
0
John Downey
Top achievements
Rank 1
answered on 10 Dec 2009, 05:43 PM
Nevermind, I figured out the correct syntax on my own:

=IIf( Fields.Implemented, 'Completed', 'Not Completed' )
Tags
General Discussions
Asked by
John Downey
Top achievements
Rank 1
Answers by
John Downey
Top achievements
Rank 1
Share this question
or