Ah, the simplest Reporting Services report can capture a user-provided parameter value and pass it to a SQL query to be executed against SQL Server which can return a rowset to be displayed as a value. This report could be in the SharePoint catalog as an ordinary page so I'm not sure how this does not meet your needs.__________________________________________________________________ William Vaughn Mentor, Consultant, Trainer, MVP http://betav.com http://betav.com/blog/billva http://www.hitchhikerguides.net Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) Please click the Mark as Answer button if a post solves your problem!

Thanks for your reply Hmm, yes i can do that in report parameters. But we're replacing an existing web page to the new sharepoint page, since all the people in my company get used to the old system, we want something similar to the existing system. For example, it has the Search: ______ text field in the footer of the page. In SSRS, we cannot assign the place for the "Parameters Prompt".. So i'm just trying to know whether there is any possibility for doing so.iPranith

Hi, I have a reporting requirement, where I need to have a webpage(in my sharepoint site) with an input text field to search in a sql server database (not inside a report, with a parameter) and display the result below my search box. Is it possible to do that? If so , how can I do that? I'm using sharepoint 2010, Sql Server 2008 R2 in integration mode. Any help or suggestion will be greatly appreciated. Thanks a lot. iPranith

Well, in that case the simplest thing to would be to create another ASP.NET page that has a ReportViewer control. In this case you can display the parameter prompt anywhere and display the report (server or local). This would take about 10 minutes to code so it should not be a big deal... ;)__________________________________________________________________ William Vaughn Mentor, Consultant, Trainer, MVP http://betav.com http://betav.com/blog/billva http://www.hitchhikerguides.net Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) Please click the Mark as Answer button if a post solves your problem!

Thanks a lot, I don't know anything about ASP.NET, It would be great if you provide some code or links to any tutorial regarding that. I just need to read a PropertyID from a text field, and retrieve SELECT * FROM Property where PropertyID ='@PropertyID' Thanks.!iPranith

Hi SQLUser2011, I would suggest you ask the question at sharepoint forum. It should be easy to achieve by sharepoint functionality. thanks, Jerry