August 5, 2013 at 12:18 pm
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
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
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
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply