Create an Onscreen Report That Contains Hyperlinks

10,7 Tạo một báo cáo trên màn hình của tôi Đó Chứa Hyperlinks người dùng có một văn bản trong lĩnh vực Khách hàng của bảng mà là thực sự của khách hàng các trang web. Người dùng muốn có thể truy cập các trang web như là một siêu liên kết trên một báo cáo trên màn hình
Nội dung trích xuất từ tài liệu:
Create an Onscreen Report That Contains Hyperlinks 10.7 Create an Onscreen Report That Contains HyperlinksMy user has a text field in his Customers table that is actually customers Web sites.Users want to be able to access the site as a hyperlink on an onscreen report. How can Iuse Crystal Report to create a report that uses hyperlinks?TechniqueFor this How-To, you wont be doing coding. Youll just adjust the formatting of a reportfield to tell it that it needs to treat the field like a hyperlink. Before doing this, you needto modify Northwind.Adding a Web Site Field to NorthwindTo accomplish this, you open the Northwind database in the Server Explorer. You thenadd a field called Website to the Customers table, with the Data Type of nchar and a sizeof 50.You then modify the first two records in the Customers table so that the Website fieldcontains www.appsplus.com and www.microsoft.com respectively, as shown in Figure10.26. Figure 10.26. These will be displayed as hyperlinks on the new report you will create.Now you are ready to create the report.Telling the Report That a Field Is a HyperlinkYou create a simple report that is based off the Customers table and contains the fieldsCompanyName, ContactName, and Website. Then you right-click on the Website field inthe report and choose Format. The Format dialog box opens, where you can click on theHyperlink tab. For the hyperlink type, you should choose Current field value (see Figure10.27). Figure 10.27. These are the options that you can have for hyperlink actions.Now that you have told the field to act like a hyperlink, you need to have it look like one.To perform this task, you set the following properties: • BorderColor. This is set to RoyalBlue to give it the color of a hyperlink. • BottomLineStyle. This is set to crLSSingleLine. • EnableTightHorizontal. This is set to True so that it doesnt highlight the full length of the field-just to the text.Thats it! When you display this in a Viewer, as shown in Figure 10.28, you can click onthe Website field, and the Viewer will bring you to the Web site you chose. Figure 10.28. This is a real-time hyperlink.StepsOpen and run the Visual Basic .NET-Chapter 10 solution. Click on the button labeledHow-To 10.7. You can click on the hyperlinks, displayed for the Web site, to go to theWeb site. 1. Modify Northwind as described in the Technique section, adding the Website field to the Customers table. 2. Create a new Crystal Report. Choose Standard for the Report Expert to use. 3. Fill in the Data tab, choosing Northwind for the database, and Customers for the table to use. 4. Choose the fields as specified by the Technique section: CompanyName, ContactName, and Website. Click Finish. 5. With the report open in Design mode, right-click on the Website field in the Details section, and choose Format. 6. Make the modifications to the format of the field as described in the Technique section, setting the hyperlink type. Then click OK. 7. Make the rest of the format changes as described, setting the BorderColor, BottomLineStyle, and EnableTightHorizontal. 8. Create a Windows Form. 9. Drag on a ReportDocument object, and set it to point to the report you created in the past few steps. Then name your report document rdHowTo10_7. 10. Place a CrystalReportViewer on the form, setting the Anchor property to Top, Bottom, Right, Left and the ReportSource property to rdHowTo10_7.CommentsNow when you run the report, you get your hyperlinks. You could have performedadditional tasks with hyperlinks, such as using the report for reviewing those you want toemail, and having the field be clickable that way.