Any particular reason we might think of, that prevents the display in alphabetical order from XFBR (not Finance) business rule? Members' name format is XXX1111. Essentially I use logic similar to the OP, but the alphanumeric values returned are not listed in alphabetical order as prescribed by linq select, but in rather random order.
Hi Koemets,
I can't think of a particular reason off-hand why it wouldn't return the correct order, but if you want to post your code, I'd be happy to look and see if anything jumps out
Dim objMembers As List(Of Member) = Nothing
If Not masterCL Is Nothing Then
objMembers = (From memberInfo In masterCL Order By memberInfo.Member.Name Ascending Select memberInfo.Member).ToList()
End If
I've never tried it in an XFBR before, but it should be doable. However, the methodology might have to be changed. I think you might have to cycle through the alphabetical list you created in this and add it to a text string to return the order back to the cube view (result being like A#XXX111, A#XXX112, etc). If I get a chance, I'll play around with it and see if I can get it to work.
