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 |
|
JeffS23
Posting Yak Master
212 Posts |
 Posted - 2009-11-25 : 13:06:14
|
| Question: In Crystal Reports, I had a Formula '@Birth Weight < 1500''@Birth Weight < 1500' was set up as follows:[CODE]IF {@Deliveries} = 1 and {aaUDS7;1.BirthWeight} > 0 and {aaUDS7;1.BirthWeight} < 1501 then 1 else 0[/CODE]The @Deliveries is set up as follows:[CODE]IF {aaUDS7;1.DeliveryType} <> 'No Entry' then 1 else 0[/CODE]I would like to build this with the same logic in SSRS. Any insight and help is deeply appreciated! |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-27 : 11:21:08
|
| something similar to:=(Iif(Fields!DeliveryType.Value="No Entry") AND Iif(Fields!BirthWeight.Value > 0) AND Iif(Fields!BirthWeight.Value<1501)), 1, 0)JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
|
|
|
SQL Reporting Srvcs - Help with an Expression