We still use Crystal Reports 9, and it works fine for our needs.

Here is a good tutorial:

http://justgeeks.blogspot.com/2008/08/using-t-sql-cursor-in-sql-server.html

But as is stated in the article, avoid this approach if possible.

If your system of ordering the records has to be in tht format you could try something along these lines (Not tested):

where right( location , len( location ) - 1...

Select top 4 location

from Locations

where location >= 'A1'

I think I've found the answer in another forum. It appears that the problem is a result of using a function in the check constraints.

A partitioning column exists on each...