Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

Data Management

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    « MongoDB: How to backup and restore databasesSlow source? Make your data flow buffers smaller! »
    comments

    This blog is part of my series Making Data Tell a Story With SSRS Properties.

    Property: Background Image

    The purpose of this property is to allow you to show an image in the background of a report, table, list, and more.

    To access the property, go to Report, Body, Table, or Matrix properties and select Background Image.

    The options are Source, Value, MIMEType, and BackgroundRepeat.

    Source:

    External – an image that can be accessed via a URL.

    Embedded – an image that is part of the report definition.

    Database – an image stored in a database, which is accessed through a dataset.

    Value:

    If External – the image URL.

    If Embedded – the image name.

    If Database – the dataset field that contains the image.

    MIMEType: the image type – bmp, jpeg, gif, png, or x-png.

    Background Repeat:

    Repeat: both horizontal and vertical.

    RepeatX: horizontal.

    RepeatY: vertical.

    Clip: image appears once, anchored in top left corner.

    Example: I want to add my company logo as the background to a report.

    Choose the Body properties. I select an embedded JPEG, set to clip.

    This is how the background image appears in Design mode:

    This is how the background image appears in Preview mode:

    Other use cases for this have been putting the words "DRAFT" or "CONFIDENTIAL" as a watermark on reports.

    Further Reading:

    Images (Report Builder and SSRS)

    Add a Background Image (Report Builder and SSRS)

    About the Author

    User bio imageJes Schultz Borland is a Consultant with Brent Ozar Unlimited, and a Microsoft SQL Server MVP. She holds an AAS - Programmer/Analyst degree, is a Microsoft Certified Professional in SQL Server 2012, and has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and SSRS. She is an active member of PASS, President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
    Social SitingsTwitterLinkedInLTD RSS Feed
    InstapaperVote on HN

    3 comments

    Comment from: David Forck (thirster42) [Member]
    Is there a way to embed an image in a report without having to deploy the image seperately to reporting services? That's what I'm currently doing in a few locations. Would love it if I didn't have to.
    01/30/13 @ 13:00
    Comment from: Jes Schultz Borland (grrlgeek) [Member]
    Jes Schultz Borland (grrlgeek) David - not that I'm aware of. What problem are you trying to avoid (or fix)?
    01/31/13 @ 15:33
    Comment from: Greg Low [Visitor] · http://sqlblog.com/blogs/greg_low
    Greg Low If you just use the "embedded" option, it MIME encodes the image into the report RDL file. But it's usually better with these sorts of images, to source them from a dataset, given the way that organizations change their logos from time to time. Either way, it doesn't have to be deployed separately.
    02/22/13 @ 19:12

    Leave a comment


    Your email address will not be revealed on this site.

    To mislead the spambots.

    Your URL will be displayed.
    (Line breaks become <br />)
    (Name, email & website)
    (Allow users to contact you through a message form (your email will not be revealed.)