How to retrive the image into Image contol based on Parameter(Admission Number) ?

Question

Hi All,

      I Need to get the Images in Report Builder Image control. Please anybody help for this query.

1. I have 2 data sets, in 1st data set i have "Admission Number " Column

in 2nd data set(form picture library) i have "Admission Number" , "Name(Image))" columns.

2. Now i want to get the image in image control based on his particular Admission Number.

Ex:    In Report Builder Selected Image Source type as "Embedded". My Parameter is Admision Number.

My Requirement:

If i enter Admission Number as 1001 and click on ViewReport, I have to get 1001 student image only into Image Control.

Query 1: IIf Parameter =1001 (Fields.AdmissionNumber.Value, "DataSet2") then LookUp(Fields.AdmissionNumber.Value, Fields.AdmissionNumber.Value, Name, "DataSet2")

=IIf(Parameters!Student_ID.Value = Fields!Admission_Number.Value, Lookup(Fields!Admission_Number.Value, Fields!Admission_Number.Value, Fields!Name__for_use_in_forms_.Value, "Stu_Images"), false)

I need like this. Please any body help for this complete query ? with above 2 querys i am getting errors.

Thanks & Regards

Ali.

---

MD.Liakath ali

Answer 1

Does the link below solve your problem?

http://road-blogs.blogspot.com/2010/04/ssrs-reports-using-database-images.html

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 2

Thank You Jason,

                   Its working for getting the data with images of all students in Table. But If i want to filter the data of particular student ?

My report server is configured in SharePoint Integrated Mode -SharePoint 2010, so i an retriving the data from SharePoint Lists.

In Report Builder 3.0 Selected Image Source type as "DataBase" Image Properties wizard

In Field : =IIf(Parameters!Student_ID.Value=Fields!Admission_Number.Value, "Stu_Images" ) Then Admisson Numbers Image should be visible into Image Control

In above query i have to Compare the Admission Number with Parameter if they are both same then that Common Admission Number Image only visible in image contol. In Data Set 2 i have Admission Number Column and Name__for_use_in_forms columns.

Can you explain me with query

Thanks & Regards

Ali

---

MD.Liakath ali

Answer 3

The blog link I have sent is for using images from the database. Can you paste the query of both your datasets here? And also, is your parameter single select or multi select?

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)