Hi pascal131313, Your report server version (10.0.2531.0) indicates that it is a SQL Server 2008 report server. However, the LookupSet function was first introduced in SQL Server 2008 R2 Reporting Services. When we deploy a report to a report server, it will verify the definition of the report. If the report definition is invalid, the deployment fails. That's why you can preview the report properly in SSRS 2008 R2 Report Designer, but cannot deploy the report to a SSRS 2008 report server. Reference: LookupSet Function (Report Builder 3.0 and SSRS) Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support

Hi pascal131313, Your report server version (10.0.2531.0) indicates that it is a SQL Server 2008 report server. However, the LookupSet function was first introduced in SQL Server 2008 R2 Reporting Services. When we deploy a report to a report server, it will verify the definition of the report. If the report definition is invalid, the deployment fails. That's why you can preview the report properly in SSRS 2008 R2 Report Designer, but cannot deploy the report to a SSRS 2008 report server. Reference: LookupSet Function (Report Builder 3.0 and SSRS) Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Mike Yin TechNet Community Support

In Microsoft Visual Studio 2008 Version 9.0.30729.4462 QFE this report I developed works just fine in the preview tab. But when I try to deploy it, I get this: Error 1 The ActionInfo.Action.Hyperlink expression for the text box Textbox11 contains an error: [BC30451] Name 'LookupSet' is not declared. 0 0 . In the TextBox11 properties by the action selection, I have this for the goto URL expression: ="https://demo.service-now.com/nav_to.do?uri=cmdb_ci_netgear_list.do?sysparm_query=nameIN"+Code.DistinctList(LookupSet(Fields!Business_Unit.Value+Fields!Location.Value+Fields!Connect_Type.Value,Fields!Business_Unit.Value+Fields!Location.Value+Fields!Connect_Type.Value,Fields!Device_Name.Value,"DataSet1")) Why would it say that LookupSet is not declared when I deploy it. How do I declare it? Again, this works perfectly in visual studio. The report server is 10.0.2531.0 standard edition, native mode

Thank you Mike, I was hoping that wasn't the answer, but now we know what the next step must be. Thanks :) Paul