expression syneax for multiple where clause

• Sharon S

  SSC Enthusiast

  Points: 155

  More actions

  March 8, 2013 at 10:18 am

  #272091

  Hi all,

  I am trying to create the Expression equivalent of the following query:

  SELECT count(TasksName)

  FROM [db].[dbo].[testdetails]

  where TopLevelProjectName = '40 Project Folder'

  and TasksName = 'Project Info'

  I basically need a working version of this incorrect syntax:

  =CountDistinct(IIF(Fields!TopLevelProjectName.Value = "40 Project Folder" AND Fields!TasksName.Value = "Project Info"))

  Thanks in advance,

  Sharon

• Sharon S

  SSC Enthusiast

  Points: 155

  More actions

  March 8, 2013 at 10:23 am

  #1595063

  ...and apologies, I thought I was in the SSRS forum when I posted this.

  Sharon

• Sharon S

  SSC Enthusiast

  Points: 155

  More actions

  March 8, 2013 at 1:51 pm

  #1595122

  Does no one reply if you accidentally post in the wrong forum?

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  March 8, 2013 at 3:03 pm

  #1595132

  Pretty much if they all thought, as I did, that you reposted it in the proper forum.