ActiveReports 18 .NET Edition
Samples / Samples / Data Binding / Section Report / Bound Data
In This Topic
    Bound Data
    In This Topic
    Show All
    Hide All

    The Bound Data sample demonstrates various ways to bind data in a Section Report.

    When you run the sample, the Viewer control displays the form with eight tabs, each with a different data binding technique. Click to select a tab, and then click the Bind To button to create the report.

    Report providing different data binding techniques

    Sample Location

    Visual Basic.NET

    https://github.com/activereports/Samples18/tree/main/DataBinding/Section/BoundData/VB.NET

    C#

    https://github.com/activereports/Samples18/tree/main/DataBinding/Section/BoundData/C#

    Run-Time Features

    The top panel of the MainForm is composed of eight tabs:

    Bind to DataSet
    Creates a DataSet from the sample database and binds it to a SectionReport object.

    Bind to DataReader
    Creates a DataReader from the sample database and binds it to a SectionReport  object.

    Bind to DataView 
    Creates a DataView from the sample database and binds it to a SectionReport object.  This tab contains a ComboBox which lets you choose the company name from the NWind database.

    Bind to DataTable 
    Creates a DataTable from the sample database and binds it to a SectionReport object.

    Bind to SQL Server
    Creates a SQL Server DataSource from a SQL server instance and binds it to a SectionReport object. The ComboBox present in this tab lets you populate the dropdown list with the existing SQL servers on the network.

    Bind to OleDb
    Creates an Oledb DataSource and binds it to a SectionReport object.

    Bind to XML 
    Creates a XML DataSource from a file and binds it to a SectionReport object. The XML tab also features a Generate XML button that generates a DataSet and saves it as an XML data file. The generated file is then used as a data source for the report.

    Bind to CSV
    Creates a CSV DataSource from a file and binds it to a SectionReport object. You can select the data type of the file from the following options:

    • Delimited Data (with or without header)
    • Fixed width Data (with or without header) 

    Project Details

    MainForm

    The MainForm uses the ActiveReports Viewer control in the bottom section of the form, and a panel docked to the top contains tabs, each with a different data binding technique.

    Click to select a tab, and then double-click the button on the tab to jump to the button's Click event in the code.

    Invoice Report

    The Invoice report uses three GroupHeader sections, a Detail section and a GroupFooter section as well as a label in the PageFooter section to display data.

    Note: Except for the Detail section, all sections come in header and footer pairs. Unused sections have their Height properties set to 0 and their Visible properties set to False.

    ghOrderHeader

    The DataField property of this section is set to OrderID. This setting, in conjunction with data ordered by the OrderID field, causes the report to print all of the information for one order ID value, including all of the related details and footers, before moving on to the next order ID.

    This section also contains a Picture control, a number of Label controls, and two bound TextBox controls. The TextBoxes are bound using the DataField property in the Properties window, and the date is formatted using the OutputFormat property.

    ghOrderID

    The DataField property of this section is also set to OrderID. This allows subtotal summary functions in the related GFOrderID section to calculate properly.

    This section contains a number of labels and bound text boxes, as well as two Line controls.

    ghTableHeader

    This section contains only labels for the data to follow in the Detail section.

    Detail

    This section contains bound TextBox controls. These TextBoxes render once for each row of data found in the current OrderID before the report moves on to the GroupFooter sections.

    GFOrderID

    The NewPage property of this section is set to After. This causes the report to break to a new page and generate a new invoice after this section prints its subtotals.

    This section contains several labels and several TextBoxes. Two of the TextBox controls use the following properties to summarize the detail data: SummaryFunc, SummaryGroup, and SummaryType. For more information, Create a Summary Report.

    The Total TextBox does not use the DataField property or any of the summary properties, or even any code. To find the functionality of this TextBox, in design view, click the Script tab at the bottom of the report.

    PageFooter

    This section has one simple Label control. For more information about report sections and the order in which they print, see Section Report Structure and Report Events.

    ProductList Report

    The ProductList report uses the Header and Detail sections to display data.

    The Header section contains a number of Label controls to display column names for the product list.

    The Detail section contains four TextBox controls to fetch the product data.