mokong -3 Newbie Poster

Hi. Good day!

Hope you could help me through this.

I'm having trouble with my customize table sorting in BIDS.

i used this formula in group sorting.

=Switch(Fields!AGE_CAT.Value = "0 - 1", 1,
	Fields!AGE_CAT.Value = "2 - 4", 2,
	Fields!AGE_CAT.Value = "5 - 9", 3,
	Fields!AGE_CAT.Value = "10 - 14", 4,
	Fields!AGE_CAT.Value = "15 - 19", 5,
	Fields!AGE_CAT.Value = "20 - 24", 6,
	Fields!AGE_CAT.Value = "25 - 29", 7,
	Fields!AGE_CAT.Value = "30 - 34", 8,
	Fields!AGE_CAT.Value = "35 - 39", 9,
	Fields!AGE_CAT.Value = "40 - 44", 10,
        Fields!AGE_CAT.Value = "45 - 49", 11,
	Fields!AGE_CAT.Value = "50 - 54", 12,
	Fields!AGE_CAT.Value = "55 - 59", 13,
	Fields!AGE_CAT.Value = "60 - 64", 14,
	Fields!AGE_CAT.Value = "65 - 69", 15,
	Fields!AGE_CAT.Value = "70 - 74", 16,
	Fields!AGE_CAT.Value = "75 - 79", 17,
	Fields!AGE_CAT.Value = "80 - 84", 18,
	Fields!AGE_CAT.Value = "85+", 19)

but it does not sort when i preview my work.

im using a stored procedure in MS SQL. it seems that the problem is the stored procedure,.. i cant modify my stored procedure, coz every day it back ups and restore.. it returns what is the original file.. what should i do.