Monday, February 28, 2011 11:27 AM
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.
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
Monday, February 28, 2011 12:03 PM
Does the link below solve your problem?
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
- Marked As Answer by Liakath Monday, February 28, 2011 12:33 PM
Monday, February 28, 2011 12:45 PM
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
Monday, February 28, 2011 2:22 PM