Introduction
What I want to do here is help out those who are just starting out with .NET 3.5 and the SSRS, if you follow the steps listed below you will be able to create your first Report.
Background
I have used VS 2008 and SQL 2005 and Linq for this example.
Steps
- Create a table for example
StudentInfo
:
- Add some data to your table:
- Create a new project using VS 2008:
- Add new item to your project:
- Select the report from the list of item:
- Enter your report name:
Now what you have to do is drag the ReportViewer
to your aspx page:
Select the datasource
of your Reportviewer
:
This how your HTML page will look:
Here are some of the steps you have to do:
Add a dataset
to your project and add a datatable
to the dataset
. I use MyDataset
and DataTable StudentInfoDataTable
. Here is the code you have to copy to your page load event:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MyDataClassesDataContext db = new MyDataClassesDataContext();
IQueryable<StudentInfo> data = from d in db.StudentInfos select d;
ReportDataSource rds = new ReportDataSource("MyDataSet_StudentInfoDataTable", data);
ReportViewer1.LocalReport.DataSources.Add(rds);
}
}
More than 15 years of experience in design, architecture and development of various commercial objects oriented application.Other Specialties
Data Migration:
• MS Access database to SQL 2005/2008
• MS Access database to Oracle
• MS Access database to My SQL
• FoxPro to SQL
Application Migration:
• Converted MS Access application to .net web application (Asp.net)
• Excel Application to .net 3.5 web application
• FoxPro application to .net 3.5
Reporting development and support
• MS access reports
• Crystal reports
• SQL Reports(SSRS)
• DevExpress reports
• Cognos reports
Application development and support
• .net Application web /Win forms
• SharePoint
• MS Access
• Website
• Ecommerce
• WCF
• Web Services
3rd Party Control Support
• DevExpress
• .netForum
• Telerik
Version controls Support
• Team Foundation Server
• Source Safe
• CVS
• SVN