C # crystal report instance

Source: Internet
Author: User

C # crystal report instance

 

 

Solution --> right-click Add new item --> crystal report --> OK, as shown in the table: Press OK (use the Report Wizard)

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

After confirmation, it appears as follows:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Select "ole db (ADO)" in "Create New Connection", as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Double-click or click "ole db (ADO)", as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Select the row where the cursor is located, and click Next at Microsoft ole db provider for SQL Server. The following figure is displayed:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Select the first option by default and click Finish directly. The previous step graph is returned, but now you can select the database you want to operate on, as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Is that true? Check whether the t74 database table you just selected already exists. OK. Click here to see if you want to operate the table, as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

OK, so that you can operate the table you want to operate. Click Next, as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Is that true? Check that all the primary and foreign key relationships are automatically matched. Click Next, as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

If you want to display any fields, you can simply add them to the right. Is it easy to use? Next: for example:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

OK. What fields do you Want to group? In ascending or descending order? Select as you wish ~. Next, the next step depends on your wishes.

Note: If you want to select a table for display, You must select a table style for display, as shown in:

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

OK. The report is still messy, as shown below,

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

But it doesn't matter. You can edit it directly and change the English to Chinese, as shown below,

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

Select a text box and right-click it. If there are many operations, you can try it on your own.

OK. The report is almost ready. How can I use it?

It doesn't matter. Let's talk about it later.

Next we will add a form, and then remove the report view from the toolbox and place it in the form.

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

This is very useful on the right. Of course, sometimes we don't need to do this, but the key moments are quite useful,

You can not display the tree on the left. You can select the crystal report you created. This is useful. Didn't we create a crystal report? This can be used here.

'20180101') This. width = '20180101'; If (this. Height> '20180101') This. Height = '20180101'; "border = 0>

In the displayed dialog box, select the created report, crystalreport2.rpt.

OK. Of course, the final result is not presented to everyone. The report is really bad. Haha, after your own innovation and carving, you will surely have a beautiful report, haha, it's done. try it.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.