Post reply

Reporting Row Order

  • August 5, 2013 at 12:18 pm

    #278323

    SSRS 2008R2:

    Here's the scenario. I have an SSRS report which is generating letters. Each data row contains the information pertinent to a letter. In the database the letters are in a specific order, by say a field called LetterOrder with the values 1,2,3,4,5..

    The letter tablix order in the report is also in LetterOrder so the report should generate the letters in LetterOrder....but it doesn't.

    So the data is stored in order, the data is read in order, the tablix sort order is set but the letters generate in a random order.

    It's almost like it's not pre-fetching the entire dataset and sorting it before rendering the letters.

    Anyone else notice something similar to this? Any ideas? Am I missing something basic?

    Regards,

    Erin

  • August 5, 2013 at 2:49 pm

    #1638746

    Good thing I fixed it.. thanks folks.

    The problem was the lowest level nesting order wasn't set.

  • August 5, 2013 at 8:22 pm

    #1638781

    Erin Ramsay (8/5/2013)

    Good thing I fixed it.. thanks folks.

    The problem was the lowest level nesting order wasn't set.

    I'm thinking that this isn't a very common problem and that's why no one replied. Thanks for posting your answer. It'll help other if they ever come across this problem and find this post.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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