C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




SQL Server Reporting Services -Part II


Posted Date: 11 Mar 2005    Resource Type: Articles    Category: .NET Framework
Posted By: sundararajan       Member Level: Silver
Rating:     Points: 10



Introduction:

This is a continuation of my previous article on SQL Reporting services..... You can view that here

Report Server:

The report server consists of the following components

1. Programmatic interfaces
2. Report Processor.
3. Data Processing Extensions
4. Rendering Extensions
5. Delivery extensions

Programmatic Interfaces:

Programmatic interfaces are those that recieves all the requests at the report server.

Rendering Extensions

Rendering extensions are those that looks after the format in which the reports are rendered. The following rendering extensions are available in the SQL2000 Reporting services.

1. HTML Rendering extension
2. Excel Rendering Extension
3. CSV rendering extension
4. XML rendering extension
5. Image Rendering extensions
6. PDF rendering extensions

Data Processing Extensions

Generally data processing extensions perform the following activities.

1. open the data source
2. analyse the query given the user and pick up the fields
3. Run a query against a data source
4. returns the set of rows

Available Data processing extensions are:
1. SQL server data processing extension
2. OLEDB data processing extension
3. Oracle data processing extension
4. ODBC data processing extension
5. Analysis Services


Delivery Extensions

These are extn=esnions that allows the delivery of reports to different locations. You can probably deliver the reports via SMTP server or deliver it to a file server. Two extensions are used for this purpose.

1. E-Mail Delivery Extension
2. File Share Delivery Extension.


Summary:

Thus we have dealt in brief about the component architecture of reporting services. This is a new thing from microsoft and it seems that this will be integrated along with SQL server 2005.



Responses
Author: Jerry    01 Apr 2005Member Level: Bronze   Points : 0
Use an WebService DataSet as a Reporting Services Data Source. Now you can go beyond and expand the capabilities of your SQLRS using WebServices. Now you can create and run your report using WebServices as sources.

http://www.rdlcomponents.com/DTE/Default.aspx




Feedbacks      
Popular Tags   What are tags ?   Search Tags  
SQL Server Reporting Services explained  .  SQL Server Reporting Services Architecture  .  SQL Server Reporting Services  .  Reporting Services  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Frequently asked questions in SQL SERVER 2000
Previous Resource: Usage of Data View Manager
Return to Discussion Resource Index
Post New Resource
Category: .NET Framework


Post resources and earn money! 		 
Related Resources


dotNet Slackers   BizTalk Adaptors    Web Design

doors in nj

Contact Us    Privacy Policy    Terms Of Use