Connecting to an XSD file as a Data Source

When you create an RPT template file, you must connect to the XSD file as the data source for the report.

  1. Create an XSD file and place it in C:\Inetpub\wwwroot\FsWebReports\Source.
  2. Create a blank report and connect to the XSD file. The file path directory varies because the XSD file can be located anywhere.
    Blank Report

    A report with multiple objects requires that the ADO.NET connect to FsWebReportTemplate.xsd.

    Each of the Object .xsd files must be listed in the FsWebReportTemplate.xml.

  3. In this example, FsWebReportTemplate.xsd is the schema for the report and the schema files for the Optiva objects are Formula.xsd and Specification.xsd.
    FsWebReportTemplate.xsd

    This example of FsWebReportTemplate.xml uses data from the Formula and the Specification. When connecting to the ADO, select FsWebReportTemplate.XSD, Formula.XSD, and Specification.XSD.

  4. Add tables to the report.
    Add Tables to Report
  5. If you add more than one table, you can view and rearrange the order of the tables, if necessary.
    Adding more than one table
  6. Change links by selecting the link and choosing Reverse Link from the shortcut menu.
    Reverse Link
  7. Now object data is available for the report. Expand a table to select any fields for the report.
    Object data fields
    Data types specified in the XSD must be available when the report is run.