LookUp function weird issue

• FedeCanalla

  SSC Veteran

  Points: 217

  More actions

  November 18, 2020 at 10:45 am

  #3809134

  I am experiencing a weird issue with the LookUp function. I have a list grouped by certain field. For example employees grouped by city. For each employee i have a column of the list where i use the LookUp function to retrieve more info from another dataset.

  So far everything works as expected.

  But i need to  format the result of the LookUp.

  And i get #Error when trying to. No matter how simple is the expresión, ir does not work.

  Example of working expression:

  =LookUp(Fields!CurrentPositionID.Value, Fields!PositionID.Value, Fields!PositionName.Value, "PositionsDataSet")

  But if i add this

  ="aaaaa" & CStr(LookUp(Fields!CurrentPositionID.Value, Fields!PositionID.Value, Fields!PositionName.Value, "PositionsDataSet"))

  I get #Error

  If i add

  =Code.Test(LookUp(Fields!CurrentPositionID.Value, Fields!PositionID.Value, Fields!PositionName.Value, "PositionsDataSet"))

  And i add Report Code

  Function Test (ByVal value as Object) As String

  Return "aaaa"

  End Function

  I get #Error too.

  Basically i need to format the LookUp result and no matter what i do, i get #Error

  Is this a bug? Is there any restriction on LookUp i do not know?

  I am using Visual Studio Community 2019 against SQL Server 2012 Express Edition

  Anyone had faced and resolved this?

  Regards.

   

   

  • This topic was modified 4 years ago by  FedeCanalla.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  November 19, 2020 at 11:10 am

  #3811533

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.