Sorting Issue in Report Studio

[ankit.agg.2008]

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.

[MFGF]

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.