October 17, 2013 at 1:34 pm
In a SSRS 2008 r2 report, I have the following sql that sorts correctly in SSIS manager.
SELECT
SA.CustNumberAS CNumber
, DS.firstNameAS FirstName
, DS.lastNameAS LastName
, admindateAS 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?
October 18, 2013 at 4:39 am
wendy elizabeth (10/17/2013)
In a SSRS 2008 r2 report, I have the following sql that sorts correctly in SSIS manager.SELECT
SA.CustNumberAS CNumber
, DS.firstNameAS FirstName
, DS.lastNameAS LastName
, admindateAS 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?
The SSRS report will show the data in the order of the query unless any other sorting or grouping is being performed on the report object itself.
Things to check (off the top of my head) :
1. Given a dataset when you add a table to the report it shows using the dataset order.
2. If you change the properties of the (Detail) group in the grouping pane by changing either the sort by or group by options then will will override the default order
3. Adding groups to the table will sort the group by the grouped item by default. The sort order within the group may not be maintained.
4. When using a matrix the row and column items are grouped therefore change the sorting.
Fitz
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply