LookupSet no longer working after v150.900.148

Gary Fuhr 96 Reputation points
2020-09-22T00:13:48.577+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,102 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2020-09-22T05:23:58.5+00:00

    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.