Hi I got it done with OPENROWSET option. It works great!!!Mano

Hi, I wanted to pull some values from remote server, actually i wanted to enter the server as a parameter input and before hitting View Report button, i wanted to list the logins present in the server which i entered earlier. Based on the resultset values i wanted to run some scripts. How do i get this done..? Not sure whether u uderstood my question. ;)Mano

There is no problem to specify a server name as a parameter in the data source.. (Google it and you will find lots of examples) ---Getting list of the logins select * from server.master.sys.server_principals See this great example http://blog.softartisans.com/2011/04/19/how-to-create-a-dynamic-reporting-services-shared-data-source-using-linked-servers/Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing MS SQL Consultants: Improves MS SQL Database Performance

Hi Uri, I wanted something like... i wil enter the server name as a input for one parameter, i also have 2nd parameter which will display the database name before i can hit the view report button. Once i hit the view report i wanted to display values on my own. Mano