SSRS (SQL Server Reporting Services) - Create Reports using SSRS - Part 1

Posted Date: 25 May 2011 |Updated: 25-May-2011 |Category: SQL Server |Author: Prabu Thangavelu |Member Level: Gold |Points: 10 |

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

Start
Programs
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)

File
New
Project
Report Server Project in New Project Pane

Specify you own Name and Location

Click OK

Select Reports in Solution Explorer Window

Right click and Select Add New Report

Click Edit

SSRS Images

SSRS Images

Select Server Name, User name, Password and Select or enter a database name
fields should be filled.

Click Test Connection and OK

SSRS2

SSRS2

Click Next >

SSRS3

SSRS3

Write your own query, as per below mentioned

SSRS4

SSRS4

Click Next >

Select Tabular

Click Finish >>|

Click Finish

Click Preview

SSRS5

SSRS5

Conclusion

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.

Reference: http://www.dotnetspider.com/resources/42874-SSRS-SQL-Server-Reporting-Services.aspx

Article by Prabu Thangavelu
Prabu Thangavelu Follow me: http://prabuthangavelu.blog.com/ or https://twitter.com/prabuthangavelu

Follow Prabu Thangavelu or read 25 articles authored by Prabu Thangavelu

Related Articles

Expressions or Functions used in SSRS

Comments

Author: Mahesh Nagar05 Sep 2011 Member Level: Gold Points : 1

very nice article thanks ..please send me more resources regarding SSRS .i am sure that must be helpful .

Author: Prabu Thangavelu06 Sep 2011 Member Level: Gold Points : 1

Hi Mahesh,

Like this article, i have posted 6 parts / articles.

Go to Resources » Articles » SQL Server

You can find other 5 articles in my name.

Read those and will be useful to you.

Author: Suresh13 Sep 2011 Member Level: Gold Points : 1

Hi Prabu Thangavelu,

It is Great Article about SSRS (SQL Server Reporting Services).

Keep it up...

Regards
S.Suresh

Author: NandhiniRavichandran16 Nov 2011 Member Level: Silver Points : 1

Hi Prabhu Thangavelu,

Thanks for your article. i tried to create a new report, but unable view report i'm getting error like " An error occurred during local report processing
Exception of type 'System.OutOfMemoryException' was thrown."
For u'r information Reporting query will return more than 12,000 records.

Author: NandhiniRavichandran16 Nov 2011 Member Level: Silver Points : 1

Hi Prabhu Thangavelu,

Thanks for your article. i tried to create a new report, but unable view report i'm getting error like " An error occurred during local report processing
Exception of type 'System.OutOfMemoryException' was thrown."
For u'r information Reporting query will return more than 12,000 records.

Author: Prabu Thangavelu16 Nov 2011 Member Level: Gold Points : 1

Hi Nandhini

First thanks for read my article and also for comments.

If you have report manager, try to deploy that report and try it.

How many datasets have you used? Find the appropriate dataset, delete that reportname.rdl.data in the corresponding folder. And come back to report, preview the same.

Try this and let me know the status

Author: NandhiniRavichandran17 Nov 2011 Member Level: Silver Points : 1

Hi Prabhu,

Thanks for your prompt reply, Once i build my report it will display all records(12,000), at the same time while preview our report i will give error. But anyhow i can able to see the all records.

And we are developed our project in VS2010.to create a report we used .rdlc(Report)form. Is it both(rdlc and rdl) are same.because i'm not clear about SSRS

Author: Prabu Thangavelu17 Nov 2011 Member Level: Gold Points : 1

Oh... That's fine.

I haven't that much of experience in VS 2010.

.rdl vs .rdlc

.rdl Report Definition Language Server-side
that means which reports created using SQL Server BIDS tool

.rdlc Report Definition Language Client-side
which reports created using Visual Studio tools

Guest Author: 04 Jan 2012

Prabu, Your article is excellent, marvelous, and amazing.

Author: Prabu Thangavelu09 Jan 2012 Member Level: Gold Points : 0

Thanks for your comments

Author: koti Balaji04 Sep 2013 Member Level: Silver Points : 0

I am a beginner
Thank you so much .. god bless helping hands

Return to Article Index

Digital Marketing by SpiderWorks Technologies, Kochi - India. ©