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 rptDrillDown1, click the drop-down arrow and select Detail. At the top right of the code window, click the drop-down arrow and select BeforePrint. This creates an event-handling method for rptDrillDown1's Detail_BeforePrint event. To write the code in C# l Click in the Detail section of rptDrillDown1 to select the section. Click on the events icon in the Properties window to display available events for the section. This creates an event-handling method for rptDrillDown1's Detail_BeforePrint event. The following example shows what the code for the method looks like: [Visual Basic] Private Sub Detail_BeforePrint(ByVal sender As Object, ByVal e As System. EventArgs) Handles Detail. B Me. txtOrderID. HyperLink = Me. txtOrderID. Text End Sub [C#] private void Detail_BeforePrint(object sender, System. EventArgs eArgs) { this. txtOrderID. HyperLink = txtOrderID. Text; } ActiveReports for . NET User Guide | 136 Viewing the report To view the report 1. Add the ActiveReports viewer control to a Windows Form. Add the code needed to set the viewer document equal to the report document. See Using the ActiveReports WinForm Viewer for help. Walkthrough: Conditional Formatting ActiveReports allows you to modify or suppress the appearance of any control at run time based on conditions in your data. This can be achieved by setting properties of the control in the section's format event based on certain conditions. This walkthrough illustrates how to create a report based on specific conditions that modify the appearance of the report at run time. This walkthrough is split up into the following activities: l Adding an ActiveReport to a Visual Studio project l Connecting the report to a data source l Adding controls to the report to contain data l Adding conditions in code to the format event l Adding code to retrieve data from the data source l Viewing the report To complete the walkthrough, you must have access to the NorthWind database (NWind. mdb). When you have completed this walkthrough, you will have a report that looks similar to the following. Adding an ActiveReport to a Visual Studio project To add an ActiveReport to your project 1. Select ActiveReports file and rename the file rptConFormat. Click Open. Connecting the report to a data source To connect the report to a data source 1. Click on the yellow report DataSource icon in the Detail section. This brings up the report DataSource dialog box. ActiveReports for . NET User Guide | 137 2. Select Microsoft Jet 4. 0 OLE DB Provider and click Next >> Click on the ellipsis to browse for the access path to NWind. mdb. Click Open once you have selected the appropriate access path. In the Query field, type "Select * from products ORDER BY 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. [. . . ] To use the WebViewer you will select an ActiveReport using the Report property of the WebViewer in the property list and set the ViewerType property to the viewer of your choice. Alternatively, you can set the Report property programmatically to a new instance of an ActiveReport class. This walkthrough is split up into the following activities: ActiveReports for . NET User Guide | 280 l Adding an ActiveReport to an ASP. NET Web application l Connecting the report to a data source l Adding controls to the report to contain data l Adding the ActiveReports WebViewer control to the Web Form To complete the walkthrough, you must have access to the NorthWind database (NWind. mdb). You must also have access to Internet Information Services either from your computer or from the server. [. . . ]