I have a report with 2 groups I am using the following to get the data from a stored procedure.
sqlSelectCommand1
.CommandText = "Exec GetStorsPayroll " + _storeid.ToString() + " , '" + strtdte.ToString() + "' , '" + enddte.AddDays(1).ToString() + "'";
sqlSelectCommand1.Connection = sqlConnection1;
sqlDataAdapter1.SelectCommand = sqlSelectCommand1;
this.DataSource = sqlDataAdapter1;
which returns the data in order of last name then first name. But when the report is displayed it is shows the data in order of the empID group. Is there a way to correct this?
1 Answer, 1 is accepted
0
Hello Chris,
Since your report has 2 groups, the grouping calculations are always accompanied by sorting by the grouping criteria. For more information please see Grouping Report Data.
In order to sort the data inside the groups you have to specify the sorting for the report as well. You can do this through the Report.Sorting collection as described in Sorting Report Data topic.
Sincerely yours,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Since your report has 2 groups, the grouping calculations are always accompanied by sorting by the grouping criteria. For more information please see Grouping Report Data.
In order to sort the data inside the groups you have to specify the sorting for the report as well. You can do this through the Report.Sorting collection as described in Sorting Report Data topic.
Sincerely yours,
Svetoslav
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center