I have a report running that runs a stored procedure. Multiple paramter values (ie order numbers) are passed from the report at run time. If I run the query from visual studio & view the results in my visual studio 'data' window the results are sorted as I want them: product first then by order no. However, when i view the results in the report window they are not sorted the same, they are sorted by order then product which is causing me problems and I cannot seem to resolve.
The report only has one paramter specified, this being order no but for which can be selected multiple values.
I dont understand why the two result sets should be diferent and how I can resolve on my printed report.