Crystal report

I was working on Crystal report with VS 2005.I made test report with sql server 2000(Northwind database).and displays record but record are showing in random order rather than any particular order.can any one help me what should i suppose to do that rcord displays in order.

This post should be directed to the Reporting forum but since it's here, the sort order can be set in a couple ways. It could be in your SQL statement or it could be directly on the crystal report itself.

Moved to reporting.