Sort on Calculated Field

[AnnieRider]

Is this possible? I have field in a table that shows Age (as calculated from DOB). I want to sort the table by Age ascending but am told I cannot sort on a Report Item.

Thanks
Annie

 

[xlbo]

Not 100% sure but you should be able to sort on an expression - you can therefore use the same logic in your expression as you have done for your report item...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnnieRider]

Thanks again )

 

[jymm]

I did this by doing the calc in the sql - then SSRS sorts stuff better / quicker in my opinion.