Pass multivalue parameter to report

[jayanthi]

Hello,

Is it possible to attach the parameter value as column name in SQLDATASOURCE?

In Sql datasource i used the below Stored procedure

declare @day as varchar
declare @Sql as varchar(3000)
set @day=1
Set @sql='select Cid,[' + @day + ']As Day1 from tbl_Amount_Track1'
Exec @Sql

Now i need to pass @day value from front end. Is it possible to pass multivalue parameter to @day from front end?


OR ELSE

Is it possible to display values of multivalue parameter straight away in report during runtime without using Sql datasource?
If so How to pass multivalue parameter to report using vb.net?

Thank you
Jayanthi

[KS]

Hi,

It is varchar, so I guess using a multivalue parameter will work. The sql wizard tutorial shows how to set the parameter.

-KS