Saturday, December 12, 2009

Installing and configuring SSRS 2005

Folks,
I have many times had the experience of trouble shooting the installation and configuring the SSRS 2005 and it made me to create a standard document to enrich this process quicker and easier.

I will be happy if you guys contact me for the document via a comment or karthik.shanth@live.com.

Content of Installation document:
--> Step by step procedure to show Installation of SSRS 2005

Content of the configuration document:
-->
1) IIS Configuration for Reports and Reportserver
2) Steps to upload the RDL files in report server
3) Create a New folder named “Reports”
4) Click on “New Data Source” menu
5) Create a new sample Data source named “DS” with the SQL server connection string mentioned in the Connection string text box to connect to the database server
6) The following screen will appear once data source has been created
7) Uploading the RDL files
8) Configuring the data sources for the Report files

Happy Reporting!!
KarthikShanth.
View Karthikeyan Shanthakumar's LinkedIn profileView Karthikeyan Shanthakumar's profile

quick bite on ssrs rendering format control

Guys, you can very well control the rendering formats of the report to your clients.

Yes. You can decide what is the export data format of your client.
Go to your reportserver installed path of your server

"C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rsreportserver.config"

Open it and search for this keys



Remove the rendering formats key which you want to hide.
You can play and control the rendering limits whenever you give the reports to your clients.

Happy Reporting!!
KarthikShanth.
View Karthikeyan Shanthakumar's LinkedIn profileView Karthikeyan Shanthakumar's profile

Introduction

I would like to write some tit bits of Microsoft SSRS in this blog. So expect something and i would welcome your comments as well which enhances me a lot :)
View Karthikeyan Shanthakumar's LinkedIn profileView Karthikeyan Shanthakumar's profile