Post reply

SSRS String Parameter issue

  • July 5, 2012 at 2:28 pm

    #258558

    Hello

    I need to pass parameter from below query

    select vcDisplaySchoolName from tblSchools

    where iSchoolCode between 100 and 499

    in to my main data set.

    i try this in my where clause

    s.vcDisplaySchoolName = '@vcDisplaySchoolName'

    but i get blank values.

    so please give me some possible solution

  • July 5, 2012 at 2:37 pm

    #1509373

    Take the quotes off the variable:

    s.vcDisplaySchoolName = @vcDisplaySchoolName

    And then again, I might be wrong ...
    David Webb

  • July 5, 2012 at 2:44 pm

    #1509374

    David Webb-200187 (7/5/2012)

    Take the quotes off the variable:

    s.vcDisplaySchoolName = @vcDisplaySchoolName

    Thanks !! That Works

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

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