CODEWITHSUNDEEP
sql-server-2008visual-studio-2008reporting-servicesssrs-2008
Mike Dole
Mike Dole

Reputation: 687

Use SSRS lookup function in Visual Studio 2008 Business Intelligence Development Studio with SQL Server 2008 R2

I'm using SSRS with SQL Server 2008 R2 which supposedly should give me an option to use the lookup function so I can use datasets from multiple datasources. My formula is:

=Lookup(Fields!ORDERID.Value, Fields!INTERTOURREF.Value, Fields!DLVNAME.Value, "dsAX")

The lookup in my formula gives a squiggly red line and a 'name lookup is not declared' error which give me the idea that it might not work with VS 2008.

Any ideas?

Upvotes: 0

Views: 775

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

The Lookup function was only added with Sql Server 2008 R2 and the original Sql Server 2008 (prior to R2) doesn't have it so you will get that error.

It sounds like you are not on Sql Server 2008 R2.

Upvotes: 1

Related Questions