Switch Statement with Different Dataset

  • Hi,

    I'm trying to come up with a Switch statement that points to a different dataset other than the primary dataset in my report. "dst2Reports" is my secondary dataset as you can see below. The coding below isn't working. Any ideas would be great!!

    =Switch(First(Fields!ReconstructionPlanned.Value,"dst2Reports")=1,"Completed",First(Fields!ReconstructionPlanned.Value,"dst2Reports")=2,"Planned for Future",First(Fields!ReconstructionPlanned.Value,"dst2Reports")=3,"Not Planned/Unneccesary"))

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply