Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lboogie
Starting Member
1 Post |
 Posted - 2005-11-15 : 11:06:41
|
| I am having a problem with the syntax of this statement. Can anyone advise. The problem that i am having is that when i only satisfy half of the condition for Complete it is still showing up as a complete project. IIF ({Command.STATUSTEXT}="Closed - Cancelled" or {Command.STATUSTEXT}="Closed - Complete","Closed", IIF ({Command.STATUSTEXT}="Approved", IIF ({@Month} = "NS" or {@Month_completed} <> 1,"Not Complete","Complete"),"Not an Approved Project")) |
|
|
Kursplat
Starting Member
1 Post |
Posted - 2005-11-25 : 12:11:45
|
| Crystal? Is there a "Crystal" version of SQL Reporting Services? Am I in the wrong forum?"No hablo Crystal." |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-28 : 00:59:03
|
| Post this question at Crystal Reports Forum to get better responseswww.BusinessObjects.comMadhivananFailing to plan is Planning to fail |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-11-28 : 16:14:02
|
Your iif condition needs to have a true or false expression so check out the second condition of your second IIF statementYou need:IIF(Condition, true, IIF(Condition, true, IIF(Condition, true, false)))
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
IIf Statement in Crystal