Hi,
I have one requirement where we need to Sort the data in List Report on the combination of two columns with different datatypes.
Example :
Reference Table Data below : there are only the two columns of the table on the combination of which sorting needs to be done.
Account No Date
3442423423 01-06-2012
3552452345 15-07-2011
3442423423 03-06-2010
3552452345 15-02-2011
I tried the concatenation, Cast function also.. If anyone faced same issue. Suggest please. Thanks.
Hi,
Sorry - I'm not seeing the issue here. Wouldn't you just sort first on the Account No and then within that on the Date?
MF.