×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SSRS - IIF

SSRS - IIF

SSRS - IIF

(OP)
Hi All,
I am trying to create a group based on certain informtation as shown below - the first group will create a different group header for each value it finds i.e it would create one if it found "Client Take on" one for "Legal" and one for "Offer Accepted"

What I want it to say is of its in this ("Client Take on","Legal","Offer Accepted" THEN "Accepted Offers/Legal"


However I cant seem to get this resolved. I cannot (alas) do in SQL as this is using a very old Lotus Notes Database to retrievethe information.

=IIF(Fields!Prospect_Stage.Value = "Client Take on" OR Fields!Prospect_Stage.Value = "Legal" OR Fields!Prospect_Stage.Value = "Offer Accepted", "Accepted Offers/Legal" ,
IIF(Fields!Prospect_Stage.Value ="Acceptance","Acceptance",
IIF(Fields!Prospect_Stage.Value ="Offer","Offers Made",
IIF(Fields!Prospect_Stage.Value ="Proposal", "Proposal",
IIF(Fields!Prospect_Stage.Value ="Survey","Survey",
IIF(Fields!Prospect_Stage.Value ="IOT", "IOT",
"99 - Other Stages"))))))

RE: SSRS - IIF

Nested iif's can be difficult to work with. I believe there is a SWITCH function in SSRS. It has been a while since I looked. Are you getting an error message or is it just not working correctly?

RE: SSRS - IIF

(OP)
Hi Kray4460
No error just wrong result set - in this one IIF(Fields!Prospect_Stage.Value = "Client Take on" OR Fields!Prospect_Stage.Value = "Legal" OR Fields!Prospect_Stage.Value = "Offer Accepted", "Accepted Offers/Legal" I get three different Group Headings - all the correct name but only want one - I will have a look at Switch though thank you

RE: SSRS - IIF

(OP)
kray4660 you a star thank you that all worked perfectly

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close