Sorting against Integer dimension
I am creating a Chart report agaisnt AS Cube.the category is a integer dimension member(Hour of Day), but in the report, the category sort in a string way, like: 1, 10,11 ... 2,20,21...is there a way to make it sort as number: 1,2,3 ... 9,10,11... Jeffrey
April 14th, 2009 11:18pm

I figure it out:)Set the Sorting of Category as: =Int(Fields!Hour.Value)Jeffrey
Free Windows Admin Tool Kit Click here and download it now
April 15th, 2009 1:23am

Thanks this helped me out!!!
October 12th, 2012 4:25pm

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

Other recent topics Other recent topics