Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting Row Order Expand / Collapse
Author
Message
Posted Monday, August 5, 2013 12:18 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, September 22, 2014 12:41 PM
Points: 544, Visits: 1,053
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
Post #1481032
Posted Monday, August 5, 2013 2:49 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, September 22, 2014 12:41 PM
Points: 544, Visits: 1,053
Good thing I fixed it.. thanks folks.


The problem was the lowest level nesting order wasn't set.
Post #1481094
Posted Monday, August 5, 2013 8:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:00 AM
Points: 35,276, Visits: 31,768
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1481135
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse