ssrs 2008 problem with visibility on tablix

• wendy elizabeth

  SSCoach

  Points: 16915

  More actions

  January 19, 2016 at 4:06 pm

  #324181

  In a new SSRS 2008 report, I am having a problem with a parameter that I call 'SReport'. I basically wanted selected tablixes to display based upon what is selected in this parameter. I basically want either:

  1. all reports, or 2. locator or 3. Cover letter tablix to display.

  I have declared the data type as Text and I want to allow Multiple values.

  Here is the sql for the dataset called Selreport that is accessed:

  BEGIN

  SELECT 'Locator' AS rptName, 1 AS rptValue

  UNION

  SELECT 'Cover letter', 2

  ORDER BY rptValue

  END

  The availalble values are dataset=Selreport, value field=rptValue, label field = rptname.

  The default values are dataset = Selreport and value field = rptName.

  The visibility on the Locator tablix is =iif(InStr(join(Parameters!report.Value, ","), 1) > 0, False, True) and this works.

  The visibility on the other tablix for Cover Letter is =iif(InStr(join(Parameters!report.Value, ","), 2) > 0, False, True) and this is not working.

  Thus would you tell me what I can do for the visibility on the other tablix for Cover Letter is =iif(InStr(join(Parameters!report.Value, ","), 2) > 0, False, True) to work?