Problems with interactive sorting with Row groups in a table

  • Hi I am developing report in SSRS using Table Item. I develop the report in which some fields are group fields and some are detail fields. I implement the interactive sort on group fields but when i click on the sorting buttons in runtime I am able to sort only using the first Group(in my case it is Region) and I can't sort by using state and othe detail fields.

    For Eg lets consider I have

    Region State Column 1 Column 2 Column 3

    east state1 blah 1 blah 2 blah 3

    state 2 blah 1 blah 2 blah 3

    West state 1 blah 1 blah 2 blah 3

    Can any one please help in this scenerio?

  • Can you change what you're sorting by from a single field to an expression? Perhaps concatenate the region, state, ... and then sort by that expression.

    Just a thought,

    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply