Thanks Craig Berntson for the help. The articles helped me to solve the issue. I had to just clear the checkmark from the option 'Use Indexes or Server for Speed' in the 'Report Options' dialog box in Crystal Reports.