Hoping someone can help with this tough one.....
I have a chart bar graph with many series. The series derive their data from DataSet1. I want to hide various series based upon a multiselect parameter. Tye multiselect parameter derives it's information from a different Dataset than the series. It's not possible for me to add a field into the data for DataSet1 and simply filtering as the amount of records would grow extremely large and performance would suffer.
This is the type of coding that I tried using in the Visibility of the Series that I want to hide:
=IIF(JOIN(Parameters!OON_Program.Value(0)).Contains("Facility_R&C"),false,true)
I also tried the below without success:
=IIF(INSTR(Join(Parameters!OON_Program.Value(0), ","),"Facility_R&C"),false,true)
Does anyone have any suggestions?
I have a chart bar graph with many series. The series derive their data from DataSet1. I want to hide various series based upon a multiselect parameter. Tye multiselect parameter derives it's information from a different Dataset than the series. It's not possible for me to add a field into the data for DataSet1 and simply filtering as the amount of records would grow extremely large and performance would suffer.
This is the type of coding that I tried using in the Visibility of the Series that I want to hide:
=IIF(JOIN(Parameters!OON_Program.Value(0)).Contains("Facility_R&C"),false,true)
I also tried the below without success:
=IIF(INSTR(Join(Parameters!OON_Program.Value(0), ","),"Facility_R&C"),false,true)
Does anyone have any suggestions?