Bad Data from an SP

[JohnEck]

I have a stored procedure that runs in SQL Server 7.0 the SP calculates a rank for sales based on month to date then compares this year to last year. The problem is when I call the stored procedure in CR to produce a report it does not order the table properly. The SP does order the tables properly when it is run under the Query analyzer in SQL Server. Does any one know if this is a CR, SQL, or PC problem.

 

[IdoMillet]

If you do any Grouping and/or Sorting
within Crystal, it could override the sort order
of data returned by the SP.

Cheers,
- Ido
ixm7@psu.edu