LookupSet no longer working after v150.900.148

Question

The following code to retrieve a list of textual descriptions for a sales contract no longer works in v150.1404.0.
In place of the descriptions, it is now printing "#Error".

=Join(
LookupSet(
CStr(Fields!BOLId.Value) + "," + CStr(Fields!DocumentTypeId.Value) + ",2",
CStr(Fields!BOLId_fk.Value) + "," + CStr(Fields!DocumentTypeId.Value) + "," + CStr(Fields!LocationId.Value),
Fields!LongDescription.Value,
"Report_BOLI_Clauses"),
vbcrlf + vbcrlf
)

This code works in 150.900.148. Does this need to be coded differently now or there's a bug in the latest version?

Answer 1

Hi anonymous user

The issue is really strange, do you mind create a new simple report and use the lookupset function again for test.

If this function still doesn't work in v150.1404.0 but work in v150.900.148,you may post the issue at (feedback forum):

https://feedback.azure.com/forums/908035-sql-server.

Once you get the official solution or feedback , you could attach the reply in the thread .

Thanks for your support and understanding.

Here is a release notes for Report Viewer controls for your reference.

https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/release-notes-ssrs-application-integration?view=sql-server-ver15

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.