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 |
|
shounen
Starting Member
9 Posts |
 Posted - 2004-05-12 : 05:07:42
|
Hosh hoooshh julle naaiers....I was hoping you guys/gals could help me with a little problem i have. I'm in the process of converting a report that i developed in Business Objects to Reporting Services. The little problem i found was that i couldnt use a if/case statement in a 'text box' in Reporting Services.I know i can bring the data into report from sql like i need but i would prefer not creating another dataset.e.g.IF SellPrice = 0 Then 0 Else ((SellPrice - CostPrice) / SellPrice)duidelik ouensShounen |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-05-12 : 06:08:01
|
| ShounenUse this formula=IIF( (SellPrice = 0), 0, ((SellPrice - CostPrice) / SellPrice) )This should do itGraham |
 |
|
|
shounen
Starting Member
9 Posts |
Posted - 2004-05-12 : 06:40:04
|
quote:
Originally posted by gpl
ShounenUse this formula=IIF( (SellPrice = 0), 0, ((SellPrice - CostPrice) / SellPrice) )This should do itGraham
It's working! thanks man  i did read up on 'iif' before posting the question but thought that it can only change the colour of the text box's value just like an alerter in Business Object. I feel like a dumb ass now...Regards,Shounen |
|
|
|
|
|
|
Reporting Services....