Hi Ed,

Actually I want to display the values in the dropdown based on some other sql query at the time of generating the report. I could not go for filter...

I am sorry i missed this. The report should be printed in client side

Thanks Todd. I found following solution and working on that. I dont know if this is efficient. But let u all know if it will work fine.

http://mikemason.ca/2007/04/30/

Thanks again.

Hi,

The following query will do that.

update

Table Name Here

set

dateofbirth = dateadd(year,-100,dateofbirth)where

Record = A

Hope this helps you.

Thanks

Hi,

The following is really a very good solution for your requirment.

http://www.4guysfromrolla.com/webtech/092105-1.shtml

Thanks.

Hi,

If possible, check with profiler when you get your system hanged out next time. It might give you a clue.

Thanks

Hi,

Could you send us the exact error you are getting when run the update query alone?.

Thanks,

Karthik

Hi,

As far as i know, there is no functionality like deleting or updating database records from reporting services.

Thanks

Hi,

Just select the property of the matrix and then add new column.