Getting the Last Value from the LookupSet
Hi, I am using Lookupset to combine 2 dataset and getting data. My expression as follows. = IIF( LookupSet(Fields!Project_Number.Value , Fields!Project_Number.Value ,Fields!Gate.Value , "Dataset2" ).Length = 0 , "SOME TEXT" , LookupSet(Fields!Project_Number.Value , Fields!Project_Number.Value ,Fields!Gate.Value , "Dataset2" )(LookupSet(Fields!Project_Number.Value , Fields!Project_Number.Value ,Fields!Gate.Value , "GovernanceMilestoneGateApproved" ).Length-1) ) LookupSet gives array of data. I want to get the last item in that array. If the length is 0, I printing some text, else the Last item in the Array. The else part works fine, If part gives as '#Error' Please help on this, Thanks.
May 19th, 2011 12:05am

Hi, I guess the issue is that you are checking the length with one dataset "Dataset2" while trying to extract the last item in another dataset "GovernanceMilestoneGateApproved". Please try replacing the GovernanceMilestoneGateApproved with Dataset2. Hope this helps. Please feel free to discuss if you have any further issues. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 7:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics