FIX: An image in a report does not appear in the preview of the report if the value property of the image is set to a URL path

Article translations Article translations
Article ID: 842537 - View products that this article applies to.
Bug #: 155269 (SQL Server 8.0)
Expand all | Collapse all

On This Page

SYMPTOMS

In Microsoft SQL Server 2000 Reporting Services, when you preview a report that contains an image, you may notice that the image does not appear in the preview. This problem may occur if all the following conditions are true:
  • The Source property of the image control is set to External.
  • The Value property of the image control is set to a URL path of an image file that is similar to the following:
    file://FullPathOfImageFile
    For example, the Value property is set to file://c:/Test.jpg.
Additionally, you may notice an error message that is similar to the following in the Output window of Report Designer:

The value expression for the image 'ImageName' contains a URL reference, which is not supported.
You may also notice this behavior when you publish and then preview the report.

RESOLUTION

To resolve this problem, obtain the latest service pack for SQL Server 2000 Reporting Services. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 1.

MORE INFORMATION

Steps to reproduce the behavior

  1. Start Microsoft Visual Studio .NET 2003.
  2. Create a new report project, and then add a new report to the project by using the Report Wizard.
  3. In Layout view, add an image control to the report by using the Image Wizard.
  4. Set the properties of the image control to the following values:
    Collapse this tableExpand this table
    PropertyValue
    ImageImage1
    SourceExternal
    ValueURLPathOfImageFile

    Note: Replace URLPathOfImageFile with an appropriate URL path of an image file. For example, the URL path is file://c:/test.jpg.
  5. Preview the report.

    You may notice the behavior that is described in the "Symptoms" section.

REFERENCES

For additional information about how to add an image to a report in Reporting Services, visit the following Microsoft Developer Network Web site:
http://msdn2.microsoft.com/en-us/library/aa255843(SQL.80).aspx

Properties

Article ID: 842537 - Last Review: April 3, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2000 Reporting Services
Keywords: 
kburl kbweb kbuidesign kbdesigner kbcontrol kbreport kbsqlserv2000rssp1fix kbfix kbbug KB842537

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com