Post reply

expression syneax for multiple where clause

  • 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

  • March 8, 2013 at 10:23 am

    #1595063

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

    Sharon

  • March 8, 2013 at 1:51 pm

    #1595122

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

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

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