Iif and format statements -- sql server reporting services

Mike
2/4/2005 9:01:05 AM

I am trying to format a database field to a Year format and check the results
against a Year value (the 2002 would become a paramater entered by the user).
Then if the results are true, then format the database field to display
month year. Below is the iif statement:

=iif(format(Fields!CREATION_DATE.Value, "yyyy") = 2002),
Format(Fields!CREATION_DATE.Value, "MMM yy"), 0)

I am getting an error stating: Argument not specified for parameter
'FalsePart' of 'Public Function IIF(Expression As Boolean, TruePart As
Object, FalsePart As Object) As Object'.

sam
2/4/2005 9:31:01 AM

Hey Mike:

You just got an extra paranthesis up there:
Try this:
=iif(format(Fields!CREATION_DATE.Value, "yyyy") = 2002,
Format(Fields!CREATION_DATE.Value, "MMM yy"), 0)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Iif and format statements