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?