---
title: "Crystal Report Using Wizard"  
description: "The Standard Report Expert is the most generic of the experts. The Standard Report Expert guides you through the process of choosing a data source and"  
author: "Chris Anderson"  
published: 2011-08-08  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/598/crystal-report-using-wizard  
category: "crystal report"  
tags: ["crystal report"]  
reading_time: 3 minutes  

---

# Crystal Report Using Wizard

##### Standard Report: The Standard Report Expert is the most generic of the experts

. The Standard Report Expert guides you through the process of choosing a data

source and linking database tables. It also helps you add fields and specify the

grouping, summarization (totals), and sorting criteria you want to use. Finally, the

Standard Report Expert leads you through chart creation and record selection.\

Cross-Tab Report: They generate summary data in a grid where the rows and

columns represent groups of data. This provides the user with a report format that

is easy to read and uses a small footprint on the page.

Mailing Label Report: The Mailing Labels Report Creation Wizard lets you create a

report that is formatted to print on a mailing label of any size. You can use the

Label screen to select a commercial label type, or you can define your own layout

of rows and columns for any multi-column style report.

![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/5bde51c0-c278-4ccf-9129-e38901b545e9.png)

Here I am using Standard Report

![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/cbeeb9d3-5a63-458f-8235-0ef8d3fcb667.png)\

Then create new [connection](https://yourviews.mindstick.com/view/83497/a-40-year-old-man-has-been-arrested-in-connection-with-the-abe-shooting). In order to establish the connection [select](https://www.mindstick.com/forum/34066/use-select-operator-in-linq) OLE DB (ADO) as datasource.

![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/97e7cd45-6b89-44a8-b135-ee196639e44b.png)\

Then select a provider from the list. Here I am selecting a SQL Server Native Client 10.0 because i am using SQL Server as a database. After selecting the provider click on next button.

\
![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/cc59f51c-94d1-4a35-8507-4e470746b00e.png)\

After selecting the provider, you have to provide the [server name](https://answers.mindstick.com/qa/110129/how-to-change-discord-server-name), user id and [password](https://www.mindstick.com/blog/118/retriving-user-password-by-using-stored-procedure-in-asp-dot-net) of the [database](https://www.mindstick.com/articles/71/how-to-create-xml-file-of-database-in-c-sharp) and select the database. If don’t want to provide userid and password then check [Integrated](https://www.mindstick.com/forum/33532/handler-pagehandlerfactory-integrated-has-a-bad-module-managedpipelinehandler-in-its-module-list) Security. After providing the necessary information click next to finish the [process](https://www.mindstick.com/forum/23018/how-can-i-create-a-process).

\
![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/3e4f0225-00ea-4c22-82bf-9aa3ca25e13f.png)\

After selecting the database you have to select the table and add it to the selected

table list, in order to show the details. Here I am selecting a customer table

from the database workbook where some customer records are present and it to

the selected tables list.\

Then click on next button.

![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/e9d357d5-b10c-4c04-8274-fc32e0001596.png)\

After selecting the table you can select the [fields](https://answers.mindstick.com/qa/96632/explain-about-relationships-and-look-up-fields-in-ms-access) from the table which you want to display in the [report](https://yourviews.mindstick.com/view/84610/fraud-allegations-by-hindenburg-to-adani-group-stated-report-of-2023) and click on the finish button. If you won’t to select the field you can drag the fields of the table from the Database field and drop it into the Details section.

\
![Crystal Report using Wizard](https://www.mindstick.com/mindstickarticle/f9b4064b-a57b-4024-a963-eb022fbf6118/images/355c15da-90c2-415f-9b0a-4ca5f5be3dc7.png)\

After finshing the process you can see the preview of the report from Main Report Preview or just run a application.

**\**

---

Original Source: https://www.mindstick.com/articles/598/crystal-report-using-wizard

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.