Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Reporting Servies

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2011-06-28 : 06:17:38
Hi All,
I have intalled the SQL Server 2005 and now i want to use reporting services. Please suggest

theboyholty
Posting Yak Master

226 Posts

Posted - 2011-06-28 : 06:48:16
Its not exactly clear what it is you want us to suggest, but if I understand you correctly, you want some advice on how to get started.

The data will need to come from SQL Server Management Studio - so write some queries and convert them into Stored Procs.

If you ticked the correct boxes during installation you'll also have installed BIDS (Business Intelligence Development Studio) - its a stripped down version of Visual Studio. This is where you build your reports.

You'll need to set up your server connection properties in BIDS so when you deploy the report, it will be accessible from the Report Manager.

Best advicse after that is to just experiment. See where it takes you.

If you need more information on the basics of Reporting Services, you'd be best advised to get a good book, find a good online tutorial or even go on a Microsoft course. SSRS can be pretty deep and there's much more to it than can be explained here.

Hope that helps.

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club
http://www.hollowtreewebdesign.co.uk - a web design company in its infancy
Go to Top of Page

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-06-28 : 08:33:34
Installing reporting services step by step
http://www.mathgv.com/sql2005docs/SQL2005ReportingServicesInstall.htm

In Love... With Me!
Go to Top of Page
   

- Advertisement -