Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Image field value trancates at #

Status
Not open for further replies.

cgomez12

IS-IT--Management
May 20, 2008
1
US
Hello all, i am having the following issue and would appreciate any assistance given, thank you!

Running SQL 2005 with Reporting Sertvices, using VS2005 to develop reports.

I have a report with an External "WEB" image which links to the image via a UNC path, like "\\server\folder\# 888 lot 48387.bmp".

The properties on this field are:
Source = External
Value = =Fields!Img.Value

Img.value is pulled from the database and the data looks like this:
file:\\server\folder\image 052377 # 142.bmp
file:\\server\folder\image 052377 # 150.bmp
file:\\server\folder\image 052377 # 155.bmp
file:\\server\folder\# 177 image.bmp

The issue is that RS2005 is truncating the image name at the "#" character. So when the report is rendered, the Img.Value looks as follows:
file:\\server\folder\image 052377
file:\\server\folder\image 052377
file:\\server\folder\image 052377
file:\\server\folder\

Why does this happen? How can i resolve?

thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top