Sorts in Visual studio

Hi,
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.

Thanks
KyliemAsked:
Who is Participating?
 
KyliemConnect With a Mentor Author Commented:
resolved by self.  please do not post to this item.

The error was that groups were applied and as usual group sorting would be applied before any column sorts.  Removed groups as not required and now fine.  :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.