I followed through the steps but eventhough after I executed "Commit tran a" the select * on dbo.test still showed me the old data: 1212121 and if I executed "Commit...

That what I thought but I am still thinking how can I deliver the multiple reports (38) for users without making them to do 38 subscriptions. Do you have any...

Thank you so much for the tips. It works for me. Thanks again.

Thanks for your help. I finally got it to work by selecting "the credential supplied by the user" and checking "Use as windows credentials when connecting to the data...

Eventhough I got the message saying "deployed successfully" there is no data source stored on the report server. I suspected may be because of the dynamic connection string or some...

Thanks. But it is the only parameter that I have in the list. Of course I try to build a dynamic connection to all servers and everything works fine under...

Hi,

I got it works under Visual Studio 2005 but after I deployed the reports to the report server and tried to access the reports I got error "Can not make...

Thank you but I need to read a column that is in Rich Text format from SQL server and at the same time convert it to a text field so...

Can I have a copy of your stored procedure that will convert the RTF field to plain text?. Thanks.

Thanks. I might type it wrong but that error message actually generated by the system.  I have changed my connection to the SQL from SQL authentication to Windows Authentication and it...