sorting error
Hi All, I have a report with drill down capabilities. The report has about 14 columns. Its grouped by first 5 columns. Recently I added sort feature using interactive sorting. Now When I clcik sort option, I get the following error. The processing of SortExpression for the text box ‘textbox7’ cannot be performed. The comparison failed. Please check the data type returned by the SortExpression. (rsComparisonError) Can anyone tell me how to fix this pls? Thanksshamen
December 22nd, 2010 10:58am

Hi Shamen, You might want to cast your sorting expression to the proper value. So if you column is a double then do something like this: =CDbl(IIF(x, y) This way you can implicitly set the result of your sorting Please let us know your feedback. Thanks KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
December 22nd, 2010 11:04am

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

Other recent topics Other recent topics