Hi all, I'm creating a pivoted report which had some 5-6 SP under a single connection & i want to change the paramater dynamically and not changing for every sP. Kindly aid me in this issue or some sample code to accomplish. Thanks, Biggie

You have to write c# code for this. Please refer to the Similar thread http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/2ea6dbe0-e35f-4359-9637-ed1f85368edb/

Thanks Will tey and get back