Add Calculated Fields to the Crystal Reports Report

10,3 Thêm Tính Fields cho báo cáo Crystal Report Mặc dù tạo ra báo cáo dựa trên các lĩnh vực được đưa ra trong bảng là tốt, nó chỉ không có sự linh hoạt tôi cần. Để có điều đó, tôi cần phải biết làm thế nào để thêm các lĩnh vực tính toán để báo cáo của tôi.
Nội dung trích xuất từ tài liệu:
Add Calculated Fields to the Crystal Reports Report 10.3 Add Calculated Fields to the Crystal Reports ReportAlthough creating reports based on given fields in tables is fine, it just does not give theflexibility I need. To have that, I need to know how to add calculated fields to my reports.TechniqueIn Crystal Reports, calculated fields are known as formulas. To create and edit formulas,you will use the Formula Editor (see Figure 10.16).Figure 10.16. You can display this Formula Editor from either the Report Expert or the Report design.When youre in the Report Expert, you can add a new formula by clicking on the Formulabutton, located on the Fields tab.In Report design, you can add a field by opening the Field Explorer, located to the left ofthe IDE with the toolbox, and expanding the Formula Fields tree. You can also right-clickon the Formula Fields base node and choose New to add a new formula.Formulas are similar to T-SQL expressions in that you can combine fields or values withoperators to create a Formula field. For example, a formula called @TotalPricePerUnit isbeing created for this How-To. You saw it displayed in Figure 10.16. The expressionused is this:{Invoices.UnitPrice}*{Invoices.Quantity}You can use Formula fields in summary sections and grand totals. The best way to verifya formula is to create it when you use the Report Expert to create a report.StepsOpen the Visual Basic .NET-Chapter 10 solution. In the Solution Explorer, you will seethe report rptHowTo10_3.rpt. Scroll over to the left so that the last column is visible. Thisis the Formula field. 1. Right-click on your project in the Solution Explorer and choose Add New Item from the Add menu item. Type the name of the report in the Name field and click Open. The Crystal Report Gallery dialog box opens. 2. Leaving the defaults as they are, which is to use the Report Export and create a Standard report, click the OK button. You are taken to the Report Expert, with the Data tab displayed. 3. Double-click on the OLE DB (ADO) node in the Available Data Sources tree. If you havent chosen a data source before, the OLE DB (ADO) dialog box opens asking you to choose an OLE DB provider. Choose Microsoft OLE DB Data Provider for SQL Server and click Next. You are requested to enter connection information. For this page, type (local) for the server, check Integrated Security, and type Northwind for the database. Click Finish. Your Available Data Sources will now indicate (Local) under the OLE DB (ADO) node and Northwind under the local connection. 4. Expand the tree under Northwind to get to the first DBO, and then expand Views. You will see the views listed, including the Invoices view. Highlight the Invoices view and click Insert Table. The view is displayed in the Tables in Report list (see Figure 10.17). Click Next. Figure 10.17. The Report Expert considers both tables and views as tables. 5. From the Fields tab, add the following fields: Invoices.CustomerName, Invoices.OrderID, Invoices.UnitPrice, and Invoices.Quantity. 6. Click on the Formula button. Type TotalPricePerUnit. Crystal Reports puts the @ before the formula name from now on. You are then brought into the Formula Editor, shown back on Figure 10.16. 7. Type the formula {Invoices.UnitPrice}*{Invoices.Quantity}; then press Ctrl+S to save and close the dialog box. An alternative is to double-click on the fields you want to include. 8. Now select the formula you just created, and add it to the fields to include. 9. You can now go on to select how you want the columns totaled and what you want the style of the report to be. Click Finish when you are done.CommentsThe Formula Editor works similarly to other builders, and its pretty straightforward touse. Formulas are another step to making sure you can give your clients the full-featuredreports they want.