SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 r2 sort problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/17/2013 :  15:35:10  Show Profile  Reply with Quote
In a SSRS 2008 r2 report, I have the following sql that sorts correctly in SSIS manager.

SELECT
SA.CustNumber AS CNumber
, DS.firstName AS FirstName
, DS.lastName AS LastName
, admindate AS AdminDT

FROM
table1


ORDER BY
DS.lastName
, DS.firstName
, SA.studentNumber
, admindate DESC

However when the report is display in SSRS 2008 report, the data is not sorted by DS.lastName first.
Each detail line header has a sort on the field header.

Can you tell me what you think can cause the problem of why the data is not sorted by last name
when the report is rendered?

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/18/2013 :  01:55:47  Show Profile  Reply with Quote
Are you applying any grouping in report?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/18/2013 :  09:18:15  Show Profile  Reply with Quote
Somehow SSRS put a sort grouping on the detail row. It must have done it by default. Is there a way to keep SSRS from putting a group sort on the detail lines?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/18/2013 :  09:26:06  Show Profile  Reply with Quote
quote:
Originally posted by jassie

Somehow SSRS put a sort grouping on the detail row. It must have done it by default. Is there a way to keep SSRS from putting a group sort on the detail lines?


you can remove the field from sorting tab in group properties.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000