Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2010-04-09 : 01:31:37
|
| Part answer: I have determined I could set the value to; =First(Fields!Image.Value) on image item 1 and =Last(Fields!Image.Value) on image item 3 but not sure how to get image for image item 2?I have 3 image items on a report within a list item. I have a stored procedure that returns the following below.3 rows returned, the last field is a binary image. The FileName field will contain a 10 digit number with _1.jpg for row 1, _2.jpg for row 2 and _3.jpg for row 3 (Example 0000000001_1.jpg, 0000000001_2.jpg, 0000000001_3.jpg). For my 3 image items on the report how do I assign each respective image from each of the rows to the image item? So image item 1 contains image from row 1, image item 2 contains image from row 2 and image item 3 contains image from row 3? Somehow need to set the value property of the 3 image items on the report to use the correct row of data and hence image.SiteID SiteName EventID CameraNumber CameraName EventType Description Cause SourceID SourceType LocalStartTime EventStartTime LocalEndTime EventEndTime Indicator ZoneNumber EventCode ZoneText DetectorText RID Media Format YearPath MonthPath DayPath EventExtraDataID FileName Type Format StartTime EndTime Image5 1 4 2 1 CAM01 EVENT Quad Alarm CAM01 EVENT 1 Cameras 2010-01-01 00:00:00 2010-01-01 00:00:00 2010-01-01 00:00:00 2010-01-01 00:00:00 NULL NULL NULL NULL NULL NULL HYIMAGES 2010 1 1 1 1_1.jpg Image HYIMAGES 2010-01-01 00:00:00 2010-01-01 00:00:00 <Binary>5 1 4 2 1 CAM01 EVENT Quad Alarm CAM01 EVENT 1 Cameras 2010-01-01 00:00:00 2010-01-01 00:00:00 2010-01-01 00:00:00 2010-01-01 00:00:00 NULL NULL NULL NULL NULL NULL HYIMAGES 2010 1 1 3 1_2.jpg Image HYIMAGES 2010-01-01 00:00:00 2010-01-01 00:00:00 <Binary>5 1 4 2 1 CAM01 EVENT Quad Alarm CAM01 EVENT 1 Cameras 2010-01-01 00:00:00 2010-01-01 00:00:00 2010-01-01 00:00:00 2010-01-01 00:00:00 NULL NULL NULL NULL NULL NULL HYIMAGES 2010 1 1 4 1_3.jpg Image HYIMAGES 2010-01-01 00:00:00 2010-01-01 00:00:00 <Binary> |
|
|
|
|
|
Selecting correct data for an image item