crystal report training under dot net training course and syllabus
Visual Studio .NET is the first Windows development environment that gives developers a fully integrated reporting solution. Crystal Reports is now installed with Visual Studio so developers can write applications that have reports seamlessly integrated into them. Starting with Visual Basic 3.0, Crystal Reports was included with the language, but not part of the default installation.
With the release of Visual Studio.NET, Microsoft finally woke up to the needs of developers. They licensed a version of Crystal Reports to be the default reporting solution installed with .NET. Built into the IDE.Windows developers now have the tools to write presentation-quality interactive reports.
CRYSTAL REPORTS
• Crystal Reports are mainly required to generate the printed copy of Reports.
• This Printed copy of reports can be generated based on the Queries passed to it.
• Crystal reports are normally designed by creating a separate “.rpt” file.
• This “.rpt” file indeed designed by user according to the Wizard/Steps.
• The Crystal Report Viewer control (ASP.NET) is used to display the “.rpt” file binded.
Creating Crystal Report:
Open Visual Studio and create a new project. This can be either VB.NET or C#, and it can be either a
Windows Application or ASP.NET. Designing reports with Crystal Reports is independent of the
application type. The following steps are the same for both types of applications.
Once the project is open, select Project | Add New Item. This displays the list of available templates.
Select the Crystal Report template.
When the Crystal Report Gallery dialog box appears, accept the defaults of "Use Report Expert" and
"Standard Report". This opens the Standard Report Expert.
The first tab shown is the Data tab. Select the Create new Connection.
Select OLEDB Provider for SQL (For SQL Server)|Next.
Provide Server Name, Chose Database, Click Next and then Finish.
Select Database, Select Tables | Add. | Next.
Select Column for Group By. |Next|
Select other appropriate options by clicking Next.
Click Finish.
Previewing a report with ASP.NET requires adding a CrystalReportViewer control to the web page and
setting its data bindings. Open the default web page in design mode and add a viewer control to it. The
viewer is located near the end of the Toolbox under the Web Forms tab. Once you add it to the form
you will see a medium sized rectangle on the web page.
Code Behind (C#)
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument orpt=new ReportDocument();
Orpt.Load(@” path of the .rpt file “);
CrystalReportViewer1.Report Source=orpt;
CrystalReportViewer1.DataBind();
}

Crystal Reports can be also generated by passing Parameters.

Apply Online