Hi i have developed stored procedure and able to generate SSRS report for the same. i have two questions here 1)i am getting data from the sql server and i need to do lot of caluclations based on some conditions,so I would like to know how to implement the code without using stored procedures 2)How to use reporting engine features effiectvely Regards, Kiran

Hi which is the best tool in the market for "Ad-Hoc Query & Reporting " Regards, Kiran

Hi I am searching a reporting tool for windows app & web app, which access Sql server DB. I am using C# coding. I am interested to do the following things: 1) a reporting tool that produces dynamic reports 2) users can select their own default view according to the information they wish to access immediately( i mean user dependant selection...like select a parameter in the application and he should be able to generate the report for that. If he selects, stocks on today date, he should get the list of all stocks and should be able to generate the report. 3) Users can independently modify or create reports 4) Reporting tool must provide security to either groups or individual, so that only those with the rights to view certain reports have access to them Can someone please point me in the right direction? I am sorry if I have requested for more insight to the reporting tool.But, I am a newbie in this and trying to work for the application. Thanks in advance for your help Regards, Kiran