Get Start with SQL Server and Reporting in 5 minutes

If you are using Sql server 2000..To open Query analyser from Run..
Use this Start->Run->isqlw->enter

Sql server 2005 and Sql server 2008 comes with Management Studio similar to Enterprise Manager in Sql server 2000.
These Management studio are free to download.
So if you dont have Visual Studio and Sql server installed in your system but you know you can access SQL server in your network you can download this and connect to SQL server

http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx

Reporting:
For reporting you need Business Intelligence which comes with installation of SQL server advanced tool kit for free download.So this will install Visual studio which is only for Reporting.

Filename:SQLEXPR_ADV

Reporting needs an Reporting server and Sql server

In Reporting Server where you will host all your reports and it can be accesses via URL.These reports are deployed to the reporting server through Business Intelligence visual studio solution.


like http://reportingServer.domainName/reportsfolder/reportFilname.rdl

Open Business Intelligence Solution similar to Visual studio solution icon but it will be placed in SQl server Installed folder (Start->All programs->Microsoft Sql server 2005->Sql server Business Intelligencedevelopment Studio)

Create a new Solution ,add a new data source .This datasource will be your database where your reports data are there.And this datasource is deployed to reporting server.
Right click on the Solution->Properties->Deployment->
Target Data source Folder:Data Sources
TargetReportFolder:reportsfolder/
TargetServerURL:http://reportingServer.domainName


Create a new Report which has file format .rdl
Now do all modifications in your report ,hook the store procedure,display those column name which returned from these storeproc...If you want to add parameters you can do that in Report parameter..

Now build the report and if it is succeeded right click on that report and properties->Deploy

This wll deploy the report to the reporting server where we mentioned on the Solution properties..

Here you go!!! Reporting for you in 5 minutes