LookupSet or MultiLookup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

LookupSet or MultiLookup

Author

Topic

tech2
Yak Posting Veteran

51 Posts

Posted - 2014-02-13 : 13:43:43

I'm trying to find an expression that I can specify a value within the field, i.e. 'Widget1'.

DataSet1
LOC ITEMNUMBER OnOrder
FL Widget1 18
FL Widget2
FL Widget3

DataSet2
LOC PARTNUMBER QUANTITY
FL Widget1 18
FL Widget2 0
FL Widget3 0

The expresion below populates all 'OnOrder' cells in dataset1 with 18, because i'm not specifying 'Widget1'. DataSet1 should look like DataSet2.

=Lookup(Fields!LOC.Value, Fields!LOC.Value, Fields!QUANTITY.Value, "DataSet3")

I have to compare two fields in each dataset 'LOC and ItemNumber', in both DataSets.

Any help would be highly appreciated.

SSRS 2008 R2 - Report Builder 3.0

Thanks

tech2
Yak Posting Veteran

51 Posts

Posted - 2014-02-19 : 20:41:32

Workaround:

I concatenated the location and item/part number Fields.

Now my Lookup expression works fine. I can pull the 'Quantity' from DataSet2 to the 'OnOrder' Field in DataSet1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources