Hi,
I am trying to sort data in a report which has groups. If I add an 'order by' to the SQL, I get an error when I try and run the Report, because PHPRunner is adding an 'order by' for the group fields. This makes the SQL statement invalid with two order by statements.
SQL From Error:
select [Team], [Description], [OfficerName]
From [dbo].[Team]
inner join [dbo].[TeamMembers] on ([dbo].[Team].TeamID = [dbo].[TeamMembers].TeamID)
inner join [dbo].[LicenceOfficer] on ([dbo].[TeamMembers].OfficerID = [dbo].[LicenceOfficer].OfficerID)
order by [Team], [OfficerName]
ORDER BY 1 ASC
How do I sort the other data (OfficerName)?
Regards,
Gordon