Microsoft KB Archive/842537

Knowledge Base

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 ID: 842537

Article Last Modified on 4/3/2007

---

APPLIES TO

• Microsoft SQL Server 2000 Reporting Services

---

Bug #: 155269 (SQL Server 8.0)

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:

   Property	Value
   Image	Image1
   Source	External
   Value	URLPathOfImageFile

   
   

   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

Additional query words: rosetta SP1 fix file url VS .NET 2003 visual studio report project

Keywords: kburl kbweb kbuidesign kbdesigner kbcontrol kbreport kbsqlserv2000rssp1fix kbfix kbbug KB842537

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.