SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 LookupSet or MultiLookup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tech2
Starting Member

42 Posts

Posted - 02/13/2014 :  13:43:43  Show Profile  Reply with Quote
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
Starting Member

42 Posts

Posted - 02/19/2014 :  20:41:32  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000