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.