Creating Summary .Net Crystal Reports - Creating Simple Crystal Reports

(Page 2 of 4 )

Assumptions

We will be using the "Northwind" database in SQL Server. This database comes with the purchase of SQL Server software. We will use the Employees table, and the following fields: EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, Photo, Notes, ReportsTo, PhotoPath

Now let's create a Windows form application using Visual Studio to simply display all employees with the title of "Sales Manager" using Crystal Reports.

Create a connection with the "Northwind" database in your application. There are different ways to make the connection. Here I created a new ODBC connection with the name "NorthWind" and added it to the application through the server explorer window.

The next step is to add Crystal Reports to your Windows application. Do the following: 

• Select the Project Menu option

• Select "Add New Item"

• Select Crystal Reports from the template.

• Click on the Add button.

• Select the "Using the Report Wizard" option.

• Choose Standard.

• Press OK.

This will open a report wizard to do data source connections and manipulate the data by selecting sorting orders, filters, groups and so on.

If you choose to create a new Crystal report, clicking on "As a Blank Report" will open a blank report for you where you can add your desired fields and manipulations.

The third option, "From an Existing Report," will create a report from a report which already exists. We will learn more about these options later in other articles I've planned and written that cover Crystal Reports.

Next: Data Source Connection >>
 

More .NET Articles
More By Madhuri Chanda

Comments On: Creating Summary .Net Crystal Reports

>>> Be the FIRST to comment on this article!