Multiple value Parameters in SSRS connecting to Teradata returns error

  • I am connecting to Teradata using SSRS and have multiple parameters, many of them that seek multiple values.

    The challenge is all these parameters may not be always filled, sometimes it could be blank. So I am using a logic as below -

    Select * from Table

    Where

    (Param1 in (?) or ? = '')

    AND

    (Param2 in (?) or ? = '')

    AND

    (Param3 = ? OR ? = '')

    This gives an error stating Something expected like a Precedes or Exists or In or contains ..........,

    Anyone experienced similar issue? Please help.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

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