I want to get the member name of a Smart List value and use that to get data via XREF from a member with that name in another PlanType.
It looks like function @SMARTLISTFROMVALUE in a DTP can do that trick but that only seems to work with a default value of the variable in the function instead of taking the ID of the Smart List value as chosen by the user.
So, function @SMARTLISTFROMVALUE("SL_Employee", [SL_Value]), only works for the Default value 5 entered into [SL_Value] and it gives me the name of the 5th member in the Smart List and the XREF also picks up that member.
But, of course, it shouldn't take the default member but the integer that actually exists in the database. My question thus is how I can push that value into variable [SL_Value] for the function.
I have tried to use @GETDATA via SL_Value = @GETDATA([SL_Employee]) but that didn't work.
Does anyone have any suggestions?
Thanks,
Fred.