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 |
|
WendyB81
Starting Member
1 Post |
 Posted - 2009-12-16 : 05:24:38
|
| HiI am hoping someone can help me. I have just started using SQL Server 2008 Reporting Serivces to create all the reports. Before I used MS Access. I can't believe the difference between the 2 when trying to enter expressions. I am trying to write an IIF statement, but it won't work in reporting services. Below is the expression I used in MS Access, wondering if anyone knows how to write it in reporting services:IIf([sce_stac]="C","Current",IIf(IsNull([sce_endd]),"No end date",IIf([sce_endd]>[cbo_reqd],"End Date after Required Date","End Date before Required Date")))Thanks in advance |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2009-12-18 : 12:30:02
|
| your fields name are wrong, if you put it in just like that it wont recognize them it should be fields.sce_endd.value or something similiar. |
 |
|
|
|
|
|
IIF Statement in Reporting Services