Adding an Image to the Report

Adding an Image to the Report

You may want to add a static image to the report, for example, a company or department logo.

To add an image to the report

1.   Open the Toolbox, click the Image item, and drag it onto the design area. The Image Properties dialog box appears. 2.   In the Image Properties dialog box, provide a name for the image (which will not be displayed), and an optional tooltip (displayed when the users hovers the pointer over the image). The Select the image source box has the following three options: ·      External: For images that exist on the report server or another external source. If you select this option, you must provide a URL to the image location in the Use this image field. If the image is changed at its source, the image in the report will change dynamically. ·      Embedded: For images that do not have to be changed. Click the Import button and browse to the image location. The image is embedded in the report and will not change dynamically. ·      Database: For images stored in the database. Provide the path of the image in the Use this field box. In the Use this MIME type box, select the appropriate MIME type for the image. 3.   The Size, Visibility, Action, and Border tabs in the Image Properties dialog box enable you to change the appearance of the image in the report, and also enable you to set the image as a link to another report or URL.

For more information about how to use images in reports, see Images in SQL Server Books Online (http://go.microsoft.com/fwlink/?LinkID=207938)

Adding an Additional Dataset to the Report

You may want to add another set of data to the same report, using a different dataset. This lets you consolidate reports into a single document for ease of reference.

To add an additional dataset to the report

1.   In the Report Data window, click New, and then click Dataset. The Dataset Properties dialog box appears. 2.   In the Name field, enter a name for the dataset or use the default. 3.   In the Data source field, select the data source, usually DataWarehouseMain. 4.   In the Query field, enter the query. This can  either a query created earlier or click the Query Designer button to create a query. When you have finished, click OK. 5.   A second dataset will appear in the Report Data window. From the Toolbox, select a Table, Matrix, Chart, or Gauge, depending on how you want to represent the data. Drag the selected control onto the design surface, and a new data item will appear in the report. 6.   From the Report Data window, drag the desired data fields onto the Table, Matrix, Chart, or Gauge tool, as appropriate.