Fill Dialog Box (Report Builder and SSRS)
On the Fill tab, you can specify color options for the background of a single cell or multiple cells within a data region or a text box.
- Fill Color
Click the color button to select a fill color for the rectangle. Click the Expression(fx) button to edit the expression, which can be a hexadecimal value for the RGB color or one of the predefined color names that are provided in the Expression dialog box. To see a list of predefined colors, in the Item pane, select Web. The color names listed in the Title pane can be typed into the expression text pane. Do not use an equal sign (=) or quotation marks ("") when typing the color name.
- Select the image source
Indicate where the image is stored so that when the report is rendered, the report processor can display it.
External Choose this option when you want the image to continue to exist as a file on a report server or Web server.
Embedded Choose this option when you want to embed the image into the report.
Database Choose this option when you want to include a database field name that represents the images that you want to include in your report.
- Use this image
This option appears when you select the Embedded or External option.
If you are embedding the image, choose the picture that you want to add to the report from the drop-down list. Click Import to add the image to the drop-down list. If you added an image to the Data pane, you can select that image by choosing Embedded and then selecting the image from the drop-down list.
If you select the External option, type the URL of the image. For a report published to a report server configured for native mode, use a full or relative path (for example, http://<servername>/images/image1.jpg). For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL (for example, http://<SharePointservername>/<site>/Documents/images/image1.jpg).
Available when you select Embedded. Click to add an image to the Use this image drop-down list.
- Use this field
Available when you select Database. Select the field name.
- Use this MIME type
Choose the appropriate format of the pictures contained in the database (for example, .bmp, .jpeg, .gif, .png, or .x-png).