Working with Images (Report Builder)

New: 14 April 2006

Images, such as logos, can be inserted into your report layout and then resized and repositioned anywhere within the report design area. For example, you can add your company's logo to the top of the first page of your report. When you add an image to the report, the image appears in an image box similar to a text box. An image must be saved in one of the following file formats in order to be added to a report:

  • Windows Bitmap (.bmp)
  • Joint Photographic Experts Group (.jpg)
  • Graphics Interchange Format (.gif)
  • Portable Network Graphics (.png)
  • Java-Python Extension (.jpe)

When inserted, the image is positioned in the top left corner of the report layout by default. If there are any other report items in the design area, they do not move to accommodate the image. You need to reposition the items when designing the report.

Note

Fields that contain images automatically display the image inside the table or matrix when the report is run. Image files cannot be inserted into a table or matrix. For more information about fields that contain images, see Working with Fields.

Formatting an Image

You can resize an image, add padding around an image, and place a border around an image. Image backgrounds cannot be filled.

Picture

When inserted, the image appears in its original size; however, you can resize it by setting the sizing options in the Format dialog box and then using the image handles that appear when the image is selected. The sizing option you select determines how you can resize the image in the design area.

Sizing Option Result

AutoSize

Displays the image proportionally at its original size.

Clip

Displays the image from the top, left corner to the height and width dimensions specified by dragging the image handles. If the image is larger than the area specified, only the portion of the image that fits in the area is displayed.

Size to Fit (default)

Displays the entire image within the height and width dimensions specified.

Fit Proportional

Displays the entire image proportionally—based on its original proportions—within the height and width dimensions specified when dragging the image handles.

Alignment

To help align the image to other report items in your report, you can add empty space, called padding, around the image. By default, the padding around an image is set to zero on all sides. Padding is specified in points.

Border

To help define the image and make it noticeable within the report, you can add a border to your image and change its color, width, and style.

See Also

Tasks

How to: Add or Remove an Image (Report Builder)
How to: Format an Image (Report Builder)

Concepts

Formatting Borders, Lines, and Gridlines (Report Builder)

Other Resources

Format Dialog Box (Alignment Tab) (Report Builder)
Format Dialog Box (Border Tab) (Report Builder)
Format Dialog Box (Picture Tab) (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance