Export (0) Print
Expand All

Creating a Report That Uses FsiDataExtension

SQL Server 2000

Creating a Report That Uses FsiDataExtension

This section contains a quick walkthrough showing how to create a sample report that uses the sample data extension.

Note  You must deploy the sample file share data extension to Report Designer and to the report server before creating a report. You must also enable the generic query designer for the extension. For more information, see Deploying FsiDataExtension.

To create the report project

  1. Click Start, point to Programs, point to Microsoft Visual Studio .NET 2003, and then click Microsoft Visual Studio .NET 2003.
  2. On the File menu, point to New, and then click Project.
  3. In the Project Types list, click Business Intelligence Projects.
  4. In the Templates list, click Report Project.
  5. In Name, type FsiReportProject.
  6. Click OK to create the report project.

To create the report

  1. On the Project menu, click Add New Item.
  2. In the Categories list, click Report Project.
  3. In the Templates list, click Report.
  4. In the Name box, type FsiReport, and then click Open.

To add a data source that uses the sample data extension

  1. In Data view, from Dataset, select <New Dataset...>.

    The Data Source dialog box opens.

  2. On the General tab, in the Name text box, type FsiDataSource.
  3. In the Type list, select File Share Information.
  4. Leave ConnectionString empty. The sample data extension does not use a connection string.
  5. On the Credentials tab, click one of the server logon types. You may enter the user name and password for the file share that your sample data extension will be accessing. Click Use Windows Authentication (Integrated Security), click use a specific username and password and enter credentials, or click prompt for credentials and enter a prompt string.

    Security Note  Whenever possible, use Windows Authentication. You will most likely be prompted for network credentials any time you attempt to access a network file share.

  6. Click OK to save the data source.

To view the dataset

  1. In Data view, the generic query designer is displayed. From Command Type, select Text.
  2. In the query pane directly below the toolbar of the generic query designer, type the path to a network file share available on your network. For example, type \\Computer1\Public.
  3. On the toolbar of the generic query designer, click the Run button (!).

    The file share data should appear in the results pane below.

To design the report layout

  1. In Layout view, in the Toolbox, click Table.
  2. On the design surface, drag and drop the Table control.
  3. From the Fields window, drag and drop the Name box to the first cell in the Detail row. Add additional fields to the table as desired.

To preview the report

  • Click the Preview tab to preview the report. Depending on your credential settings for your FsiDataSource, you may be required to enter a user name and password.
See Also

Implementing a Data Processing Extension

Sample File Share Data Processing Extension

© 2014 Microsoft