Home Forums Reporting Services Reporting Services 2005 Development parameter in dataset RE: parameter in dataset

  • September 9, 2013 at 10:37 am

    #1648608

    Snigdha Vartak (8/17/2013)

    You may use dynamic SQL statements. something like,

    --@schema is parameter

    Declare @val1 nvarchar(500)

    SET @val1 ='Select * from ' + @schema+'.'+'TableName'

    execute(@val1)

    In similar case, Dynamic SQL worked for me.