Lookup function issue or specific cell data binding problem

i  have dataset has datatable having 2 columns i.e

table( id string,value string)

every single record in datatable represents answer particular question, id column being question identifier , value column  being answer , every question has answer being stored 7 days.

now have designed report in form of grid like

                     day1 answer, day2 answer, day3 answer............................day7 answer

question 1 

question 2

..

.

.

.

.

.question 40

i tried using lookup function in ssrs reporting service bind every single cell in report using data dataset like

= lookup("question_identifier",questionid.value,answervalue.value,"mydataset");

the report working absolutely fine in report designer expected when take asp.net website have generate it, never shows , report couldn't found , make sure have published report kind of errors.

i figured problem lookup function because removed lookup function expressions in report , report started show without data.

please let me know if there way go around problem or fix issue.

thanks,

br,

hi br,

the kind of error “report couldn't found , make sure have published report “means cannot find report in specified destination. can caused report not published, or there typo in report path.

besides, lookup functions included in visual studio 2012 , later versions, can use function in particular versions. more details, please see:
http://msdn.microsoft.com/en-us/library/ee960138(v=vs.110).aspx

hope helps.

thanks,
katherine xiong

---

katherine xiong
technet community support

SQL Server  >  SQL Server Reporting Services, Power View