User manual MICROSOFT ACTIVEREPORTS FOR .NET

[. . . ] ActiveReports for . NET User Guide | 1 ActiveReports for . NET User Guide ActiveReports for . NET User Guide | 2 Table Of Contents ActiveReports for . NET User Guide Introducing ActiveReports for . NET ActiveReports Editions Standard Edition Features Professional Edition Features Data Dynamics Copyright Notice ActiveReports for . NET License Agreement and Limited Warranty Frequently Asked Questions Installation and Setup Hardware and Software Requirements Installed Files Troubleshooting Installation Verifying Package Installation Upgrading Reports Changes Between ActiveReports 2. 0 and ActiveReports for . NET Converting Microsoft Access Reports Migrating from ActiveReports 2. 0 Architecture and Concepts Events Hyperlinks Layout Files Localization OutputFormat Strings Parameters Report and Page Settings Report Execution Report Structure Scripting Getting Started ActiveReports Designer Using the ActiveReports WinForm Viewer 8 8 8 8 9 9 10 11 12 12 13 14 14 14 14 15 15 15 16 16 17 17 17 18 19 22 23 23 24 25 25 ActiveReports for . NET User Guide | 3 Adding a Report to Your Project Design Surface Loading an Existing Report Layout Report Menu Toolbars Toolbox Adding ActiveReports Controls to the Visual Studio Toolbox Adding an ActiveReport to a Visual Studio . NET Project Adding Field Expressions Binding Reports to a Data Source Using a Data Set Using a Data View Using the DataSource Icon Grouping Data Licensing Applications Localizing the Viewer Control Using Metric Units Saving and Loading RDF Files Saving and Loading RPX Files ActiveReports and the Web ActiveX Viewer Control Manually Configuring Web Samples Using Export Filters Getting Assistance Readme File Product Support Product Registration Technical Support Samples and Walkthroughs Samples Standard Edition Samples Annual Report Sample 26 27 28 28 29 29 30 31 33 33 33 34 34 35 36 36 38 38 39 40 40 43 46 47 47 48 48 48 49 49 49 50 ActiveReports for . NET User Guide | 4 ASP. NET Standard Edition Web Sample Category Selection Sample Cross-Tab Sample Custom Preview Sample Data Reader Binding Sample Data View Binding Sample DataGrid Printing Sample E-mail Sample Hyperlinks and Drill-Down Sample RDF File Viewer Sample Report Assemblies Sample Unbound From Array Sample Unbound From Text File Sample XML Data Sample Professional Edition Samples ASP. NET Web Sample End-User Report Designer Sample Walkthroughs Standard Edition Walkthroughs Walkthrough: Data Bound Reports Walkthrough: Unbound Reports Grouping Data Walkthroughs Walkthrough: Conditional Show-Hide Detail Walkthrough: Group on Simple Fields Group on Unbound Fields Walkthrough: KeepTogether Options Page Numbering Walkthroughs Walkthrough: Page Numbering in the Group Header Walkthrough: Page Numbering in the Page Footer Walkthrough: Summary Fields Walkthrough: Calculated Fields Bookmarks Walkthroughs Walkthrough: Bookmarks with Grouping 50 51 51 51 51 51 52 52 52 52 52 53 53 53 53 53 53 54 54 55 57 61 61 64 66 71 73 73 76 79 81 83 84 ActiveReports for . NET User Guide | 5 Walkthrough: Bookmarks with Simple Reports Walkthrough: Bookmarks with Subreports Walkthrough: Rich Text and Field Merging Master Detail Reports Walkthroughs Walkthrough: Master Detail Reports with Grouping Walkthrough: Master Detail Reports with Subreports Walkthrough: Master Detail Reports with XML Data Subreports Walkthroughs Walkthrough: Hierarchical Subreports Nested Subreports Walkthrough: Simple Subreports Parameters Walkthroughs Walkthrough: Parameters with Simple Reports Walkthrough: Parameters with Subreports Hyperlinks Walkthroughs Walkthrough: Hyperlinks Walkthrough: Hyperlinks and Bookmarks Walkthrough: Hyperlinks and Simulated Drill-Down Reporting Walkthrough: Conditional Formatting Walkthrough: Using Data Sets Containing Relationships with Subreports Run-Time Reporting Walkthroughs Walkthrough: Creating and Modifying Report Layouts at Run Time Walkthrough: Modifying the Report Data Source at Run Time Walkthrough: Creating Advanced Report Layouts Modifying Report Documents Walkthroughs Walkthrough: Adding Pages Walkthrough: Applying Page Templates Walkthrough: Merging Reports Walkthrough: Style Sheets Scripting Walkthroughs Walkthrough: Scripting and Simple Reports Walkthrough: Scripting and Subreports 87 89 94 99 100 102 105 107 107 110 114 117 118 119 122 123 125 130 136 139 144 144 153 155 157 157 161 164 167 169 169 172 ActiveReports for . NET User Guide | 6 Printing Walkthroughs Walkthrough: Duplexing Walkthrough: Multiple Copies Walkthrough: Orientation Walkthrough: Scaling Pages Walkthrough: Customizing the Viewer Control Walkthrough: Using ActiveX Viewer Control on the Web Walkthrough: Exporting Output Walkthrough: Saving and Loading to a Memory Stream Web Custom Exporting Walkthroughs Walkthrough: Custom Exporting with HTML Walkthrough: Custom Exporting with PDF Walkthrough: Custom Exporting with Excel Walkthrough: Custom Exporting with TIFF Walkthrough: Custom Exporting with RTF Custom Exporting with Plain Text Walkthrough: Deploying Compiled Reports Custom Controls and ChartFX Web Services Walkthroughs Data Set Web Service Data Set Windows Application ActiveReports Document Web Service ActiveReports Document Windows Application Localization Walkthroughs Localizing the Active Reports Viewer control Localizing the ActiveReports Designer Localizing the ActiveReports Engine Professional Edition Walkthroughs Creating an End-User Report Designer Walkthroughs Walkthrough: Creating the Basic Layout for an End-User Report Designer Walkthrough: Adding Code for the End-User Report Designer Walkthrough: Adding Code for the Main Menu Walkthrough: Adding Code for the Property Grid 176 177 178 179 181 183 185 188 190 193 193 199 202 205 208 210 213 214 216 216 217 219 221 223 223 227 231 234 234 235 237 239 241 ActiveReports for . NET User Guide | 7 Walkthrough: Configuring the ActiveReports Toolbox Walkthrough: Adding Code for the ActiveReports Toolbox Walkthrough: Configuring the Layout Toolbar Walkthrough: Adding Code for the Layout Toolbar Walkthrough: Configuring the Report Toolbar Walkthrough: Adding Code for the Combo Boxes Walkthrough: Adding Code for the Report Toolbar Walkthrough: Adding a Viewer Control for the End-User Report Designer Walkthrough: Deploying ActiveReports Web Applications Configuring the HTTP Handlers Walkthrough: HTTP Handlers Walkthrough: Web Viewer Control 242 244 245 248 255 258 263 271 273 274 277 279 ActiveReports for . NET User Guide | 8 ActiveReports for . NET User Guide ActiveReports for . NET is a fully-integrated product which combines the features of the Visual Studio programming languages with user-friendly controls to provide a powerful report designer. In the ActiveReports for . NET Documentation Introducing ActiveReports for . NET Find out more about ActiveReports for . NET, installation and setup information and the features of the standard and professional editions. Getting Assistance Find out the location of the Readme file and how to obtain product support. Samples and Walkthroughs Find out how to use different features of ActiveReports in the available samples and walkthroughs. Introducing ActiveReports for . NET ActiveReports leverages the latest technologies including XML, scripting and CSS along with open architecture to provide you with a fully-integrated and user-friendly report designer. [. . . ] At the top left of the code view for rptBookmarks, click the drop-down arrow and select (Base Class Events). At the top right of the code window, click the drop-down arrow and select FetchData. This creates an event-handling method for rptBookmarks' FetchData event. To write the code in C# l Click in the gray area below rptBookmarks to select the report. Click on the events icon in the Properties window to display available events for the report. This creates an event-handling method for rptBookmarks' FetchData event. The following example shows what the code for the method looks like: [Visual Basic] Private Sub rptBookmarks_FetchData(ByVal sender As Object, ByVal eArgs As DataDynamics. ActiveRepor ActiveReport. FetchEventArgs) Handles MyBase. FetchData If iEntry > pBM. Count - 1 Then eArgs. EOF = True Else eArgs. EOF = False iEntry += 1 End If End Sub [C#] int iEntry; private void rptBookmarks_FetchData(object sender, DataDynamics. ActiveReports. ActiveReport. FetchEven { if (iEntry > pBM. Count - 1) { eArgs. EOF = true; } else { eArgs. EOF = false; iEntry += 1; } } Viewing the report To view the report 1. Add the code needed to set the viewer document equal to the report document. See Using the ActiveReports WinForm Viewer for help. Walkthrough: Hyperlinks and Simulated Drill-Down Reporting Hyperlinks can be used in Active Reports to simulate drill-down reporting. This walkthrough illustrates how to set up hyperlinks in a report to simulate drill-down reporting. This walkthrough is split up into the following activities: l Adding three ActiveReports to a Visual Studio project l Connecting each report to a data source l Adding controls to each report to display the data l Adding three Windows Forms to the project l Adding code to frmViewMain and frmViewDrillDown1 l Adding the code needed to set hyperlink properties ActiveReports for . NET User Guide | 131 l Viewing the report To complete the walkthrough, you must have access to the NorthWind database (NWind. mdb). When you have finished this walkthrough, you will have a report that looks similar to the following. Adding three ActiveReports to a Visual Studio project To add three ActiveReports to a Visual Studio project 1. Select ActiveReports file and rename the file rptDrillDown1. ActiveReports for . NET User Guide | 132 7. Click Open. Connecting rptMain to a data source To connect the report to a data source 1. Select Microsoft Jet 4. 0 OLE DB Provider and click Next >> Click on the ellipsis to browse for the access path to NWind. mdb. In the Query field, type "Select * from customers order by customerID". Click OK to return to the report design surface. Connecting rptDrillDown1 to a data source To connect the report to a data source 1. Select Microsoft Jet 4. 0 OLE DB Provider and click Next >> Click on the ellipsis to browse for the access path to NWind. mdb. In the Query field, type "Select * from orders where customerID = '<%customerID%>' order by orderdate". Click OK to return to the report design surface. Connecting rptDrillDown2 to a data source To connect the report to a data source 1. Select Microsoft Jet 4. 0 OLE DB Provider and click Next >> Click on the ellipsis to browse for the access path to NWind. mdb. In the Query field, type "Select * from [order details] where orderID = <%orderID%> order by productid". [. . . ] Select Microsoft Jet 4. 0 OLE DB Provider and click Next >> Click on the ellipsis to browse for the access path to NWind. mdb. In the Query field, type "Select * from products ORDER BY categoryID, productname". Click OK to return to the report design surface. Adding controls to the report to contain data To add controls to the report 1. Make the following changes to the group header: ¡ Change the name to ghProducts ¡ Change the DataField property to CategoryID ¡ Change the GroupKeepTogether property to First Detail ¡ Change the KeepTogether property to True 3. Add the following controls to the GroupHeader section: ActiveReports for . NET User Guide | 279 Control Label Label Label Label 4. [. . . ]