when iam select all report not reflect the data other wise its work

want more details.

Hi if you are trying to have multi-valued parameter. I have uploaded a video on how to create a multi-valued parameter. Follow that process, I am sure this issue will go away. http://www.bitipsntricks.com/?p=303 Hope this helps.regards Natraj www.BItipsntricks.com Mark as Answer, if it is answer for your Question. Vote as Helpful, if it is helpful to you.

Hi ram4128, Based on your description, it seems that you select multiple-values parameter for a report does not work. Right? If so, there is an article about “Adding Parameters to Select Multiple Values in a List”, please see: http://msdn.microsoft.com/en-us/library/aa337396(v=SQL.100).aspx If not, please post more detail information to us for the further investigation. Regards, Bin LongBin Long TechNet Community Support