Viewing 2 posts - 61 through 62 (of 62 total)
Snigdha Vartak (9/4/2013)Parameter formatting is not supported in SSRS. You can not control the parameter field size, positions.
Snigdha Vartak (9/4/2013)
It's not possible to change the parameter control with BIDS in SSRS. However,you...
September 9, 2013 at 2:16 pm
#1648654
Snigdha Vartak (8/17/2013)You may use dynamic SQL statements. something like,--@schema is parameterDeclare @val1 nvarchar(500)SET @val1 ='Select * from ' + @schema+'.'+'TableName'execute(@val1)
Snigdha Vartak (8/17/2013)
--@schema is parameter
Declare @val1 nvarchar(500)
SET @val1 ='Select * from ' + @schema+'.'+'TableName'
execute(@val1)
In similar case, Dynamic SQL worked for me.
September 9, 2013 at 10:37 am
#1648608