SSRS (SQL Server Reporting Services) - Create Reports using SSRS - Part 1
I would like to share my thoughts about creating a new reports using SSRS tool and designing the customised reports. Even though many of them knows about SSRS, this is the article for people who are struggling to how to start, design, connect with databases and deploy reports.
SSRS (SQL Server Reporting Services)
SSRS is a specialised reporting tool to create, design and deploy reports using SQL Server Environment and those reports can be exported in several different formats like Excel, XML, PDF, CSV, HTML and TIFF.
Designing Reports using SSRS
Microsoft SQL Server 2005
SQL Server Business Intelligence Management Studio
(Note: If you not find out, first install Visual Studio 2008 and then install SQL Server)
Report Server Project in New Project Pane
Specify you own Name and Location
Select Reports in Solution Explorer Window
Right click and Select Add New Report
Select Server Name, User name, Password and Select or enter a database name
fields should be filled.
Click Test Connection and OK
Click Next >
Write your own query, as per below mentioned
Click Next >
Click Finish >>|
You can edit your own reports how you expect and enjoy with reports.
You can reach me at any time if you face any issue in this.
very nice article thanks ..please send me more resources regarding SSRS .i am sure that must be helpful .