Post reply

SSRS REPORT

  • January 20, 2023 at 7:53 pm

    #4140158

    Hello team Parameters that return nothing because of High value returned

    here is the Query Parameter Dataset as following

    SELECT

    MMTUCERT.TECH.LAST_NME || ', ' || MMTUCERT.TECH.FRST_NME Name

    FROM

    MMTUCERT.TECH

    Order by Name asc

    Here is syntacs  that used in my main query

    (

    'ZZZyyyXxz' IN(:NME)

    OR

    MMTUCERT.TECH.LAST_NME || ', ' || MMTUCERT.TECH.FRST_NME IN (:NME)

    )

    Here is my Expression

    =IF(Parameters!NME.Count>999, "Z", Parameters!NME.Value)

    thank for the Help

     

  • January 20, 2023 at 8:31 pm

    #4140167

    That's Oracle syntax. Are you connecting to a SQL Server database?

  • January 20, 2023 at 8:33 pm

    #4140169

    yes

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

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