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. |