?
Solved

Sorts in Visual studio

Posted on 2008-10-06
1
Medium Priority
?
309 Views
Last Modified: 2013-11-26
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
0
Comment
Question by:Kyliem
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
Kyliem earned 0 total points
ID: 22649987
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

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question