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"))