April 8, 2013 at 9:46 am
I have a view designed on a sql 2008 r2 database that has all the information to display that I need.
In this is the UNC path to an image I need to display. the image resides in a fileshare on another server on the same network.
I can't get the image control to display the image.
Any help is greatly appreciated.
I am using Report builder 3.0
I have tried
source = external
value = fields!photopath.value
value = "file:" + fields!photopath.value
The text in photopath.value is "\\fileserver\databases\saag\pictures\default.jpg"
Nothing seems to work.
This is the error I get when I try and run the report with the Image3.value = "File:" + fields!photopath.value
The Value expression for the image ‘Image3’ refers to the field ‘photopath’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
----------------------------
The definition of the report 'Main Report' is invalid.
----------------------------
An error occurred during local report processing.
Help
Thank you in advance,
April 9, 2013 at 8:40 am
It sounds like you are trying to use the image outside of a data region (Table, Matrix, List) which has a data set assigned to it. I assume this is a single image and not a different image per row in the data set? IF so you can do some thing like this:
=Lookup("[Key Value to Search On]", Fields![Key Field].Value, Fields!photpath.Value, "[Dataset Name]")
Or
=First(Fields!photopath.Value, "[Dataset Name]")
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 9, 2013 at 9:27 am
I am looking to place an image for every record. I did get this solved.
Turns out Report Builder is Case Sensative.
image1.value = "File:" + fields!PhotoPath.value
the field PhotoPath had capital "P" when designed and report builder needed to have the capital P's.
Thank you,
Steve
April 9, 2013 at 9:52 am
Glad you figured it out. Doesn't really seem to make sense that report builder would be case-sensitive when BIDS isn't :crazy:
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply