SQL Server 2005 Reporting Services (SSRS).
 
 Installing SSRS creates two new virtual directories under the default website on IIS. By default, they are named Reports and ReportServer. The ReportServer site hosts a web service for running and managing reports. The Reports site allows you upload reports from a browser and run reports over the web.
 
ReportServer and ReportServerTempDB databases are created after installation
 
 
In vs editor u will get Business Intelligence Templates (One report wizard and second one Reports)
 
using shareddatasource create datasource then rdl file.
 
Then u have to deploy (if it is local then it is http:localhost/reportserver in TargetServerURL
 
Then open web or windows application. Drag a report viewer control on to the form
 

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote

ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://localhost/reportServer")

ReportViewer1.ServerReport.ReportPath =

"/SSRS/Report2"

Dim params(0) As Microsoft.Reporting.WebForms.ReportParameter

Dim p As Microsoft.Reporting.WebForms.ReportParameter

p = New Microsoft.Reporting.WebForms.ReportParameter("contract", TextBox1.Text)

params(0) = p

ReportViewer1.ServerReport.SetParameters(params)

ReportViewer1.ServerReport.Refresh()

the above code we have to write .

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-3-the-chart-control/

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-reporting-services-part-4/

How to  add a data (coming from database ) to report header: (I solved one issue today)

———————————————

U can’t directly display a field in page header of the report..

 

Refer this link to display a field in page header

http://blog.irm.se/blogs/eric/archive/2006/05/25/Reporting-Services_3A00_-Data-in-a-Page-Header.aspx

 

It says u need to create a dummy parameter for this field to get displayed in page header

 

1)     create a parameter and set these values :

(a)Name-give some name

    Prompt-leave blank,don’t give anything,otherwise it will display like any other parameters of the RDL or SP

(b) available values-nothing to do with this section

©   default values- select “from query” ,dataset-give the datasetname

                                                         Value field- select the field name from the drop down

 

 

And then click ok

 

In the page header drag and drop a textbox

 

There u can put the parameter name which ever u have created using the above procedure

 

 

That’s all.

 

 

Useful links for reporting services:

 

1)     http://technet.microsoft.com/en-us/library/bb395166.aspx

2)     http://download.microsoft.com/download/c/2/0/c2091a26-d7bf-4464-8535-dbc31fb45d3c/rdlNov05.pdf

3)     http://download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/reporting_services_design.doc

4)     http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/reportdesigntips.doc

 

Report Definition Language (RDL)

Using the Report Builder tool

The Report Builder is a neat addition to the SSRS package. It allows developers to create a tool that is delivered to the user via the web, using one-click deployment. The tool allows the user to select from pre-defined fields and functions as the basis for building their own reports.

By using this we can give customer a reporting tool.

Report Builder allows you to deliver an Ad-hoc reporting tool to you clients. If you find yourself constantly having to produce custom reports for various clients, all off the same data, then this is the tool for you. It allows you to transfer that control to your customer’s hands. That frees you up to do more important work and your customers may even enjoy designing their own reports. For your part you free up your time and look like a hero to your customers and your boss.

Dundas charts : Microsoft

Advertisements

About ambatisreedhar

Developer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s