This topic explains
article about SSRS. If you want better understanding of SSRS, we suggest to try
ASPHostCentral and you can start
from our lowest Standard Plan @4.99/month
to host your SSRS site.
If you have written any reporting applications in .NET, you may be familiar
with Crystal Reports and/or Microsoft SQL Server Reporting Services.
The ReportViewer control
is a new addition to Visual Studio 2005, which is actually a Reporting Services
component. This control has two versions - Windows Forms version and Web
version. As you may presume, Windows Forms version is used to write reporting
applications in Windows Forms applications and Web version is used to write
ASP.NET Web applications.
Report Processing
Modes
The ReportViewer control
supports two report processing modes - local
and remote.
In local processing mode, the ReportViewer
control runs within the client application and the report processing is
performed as a local process on the client machine where actual application is
running.
In remote processing mode, the
ReportViewer control runs on a SQL Server 2005 Reporting Services report
server. In this mode, the ReportViewer control is used to view the report that
is already generated on the server. All processing from data retrieval to report
rendering is performed on the report server. To use remote processing mode, you
must have a licensed copy of SQL Server 2005 Reporting Services.
Both Windows and Web
controls can be configured to run in local processing mode or remote processing
mode.
Namespace and
Assembly
The
ReportViewer control assemblies for Windows Forms and Web Forms versions
are Microsoft.ReportViewer.WinForms and Microsoft.ReportViewer.WebForms
respectively. You must have to import the namespace in your application before
start using the ReportViewer control. If you use add the ReportViewer control
by dragging and dropping from the Toolbox, the namespace and assembly
references are added for you automatically.
Create a Simple Report
Now let's create a
simple report using the ReportViewer control. In this application, we will load
data from a SQL Server database to generate reports.
1. Create a Web Application using Visual Studio 2005
2. Drag and drop a ReportViewer control from Toolbox to the Web page
3. Right click on the Project in Solution Explorer and select Add New Item menu
item and select DataSet from the list and keep DataSet1.xsd as name.
4. The next screen is TableAdapter wizard, which asks you question about your
database connection and SQL queries where you want data to be selected from.
Just follow the wizard steps one by one and you will end up seeing DataSet in
designer mode with your table name and columns. Close the designer.
5. Now right click on the Project again and select Add New Item and select
Report from the available items and click Add button.
6. It will add Report.rdlc file to your project and will open the report
designer. As you can see in the left side, you will see your DataSet.
7. Now you can expand your DataSet and drag whatever column you want in the
report to the report designer.
8. Now if you right click and select Properties on a TextBox, you can apply
settings like visibility, navigation, format, font, and sorting. For now, you
can say OK on this dialog.
9. Now go to the Web page and click the smart tag on ReportViewer and select
Report.rdlc from the list.
10. That's it. Now if you run the application, you will see report. You
can navigate through records, and export it to Excel or PDF using the Export
option.
Summary
The ReportViewer
control available in Visual Studio 2005 makes reporting easier for .NET
developers. This article was a basic introduction to ReportViewer control and
how to get started with it. Now having Reporting Services component available
in Visual Studio, you don't have to deal with Crystal Report, its distribution
and licensing issues.
Top Reasons to trust your SSRS website to
ASPHostCentral.com
What we think makes ASPHostCentral.com so compelling is how
deeply integrated all the pieces are. We integrate and centralize
everything--from the systems to the control panel software to the process of
buying a domain name. For us, that means we can innovate literally everywhere.
We've put the guys who develop the software and the admins who watch over the
server right next to the 24-hour Fanatical Support team, so we all learn from
each other:
- 24/7-based Support - We never fall
asleep and we run a service that is operating 24/7 a year. Even everyone is on
holiday during Easter or Christmas/New Year, we are always behind our desk
serving our customers
- Excellent Uptime Rate - Our key
strength in delivering the service to you is to maintain our server uptime
rate. We never ever happy to see your site goes down and we truly understand
that it will hurt your onlines business. If your service is down, it will
certainly become our pain and we will certainly look for the right pill to kill
the pain ASAP
- High Performance and Reliable Server
- We never ever overload our server with tons of clients. We always load
balance our server to make sure we can deliver an excellent service, coupling
with the high performance and reliable server
- Experts in SSRS Hosting - Given
the scale of our environment, we have recruited and developed some of the best
talent in the hosting technology that you are using. Our team is strong because
of the experience and talents of the individuals who make up ASPHostCentral
- Daily Backup Service - We realise
that your website is very important to your business and hence, we never ever
forget to create a daily backup. Your database and website are backup every
night into a permanent remote tape drive to ensure that they are always safe
and secure. The backup is always ready and available anytime you need it
- Easy Site Administration - With
our powerful control panel, you can always administer most of your site
features easily without even needing to contact for our Support Team.
Additionally, you can also install more than 100 FREE applications directly via
our Control Panel in 1 minute!
Happy hosting!