Hi all,

 

My application was running on Visual studio 2002 i.e framework 1.0  . Now I have migrated  the application from Framework 1.0 to framework 3.0 .   Every thing works fine with some fixes.

 Only problem as of now is with  Crystal reports  .

In crystal reports sorting was not working , So I manually passed the values to Stored procedure  for sorting and than displaying those values on reports , But even though  Stored Procedure is returning correct Result with sorted data set , the report  displayed using CR is not showing the sorted list , Can some one please help w.r.t to this Issue.

 

Hi all,

Its not the code wrong.

The reason for this problem was:

As Sorting was not working after Upgrading the Crystal reports to Version=10.5.3700.0,  Sorting was handled in the stored procedure.
But the crystal report which was taking data from the Data Set was not refreshed , when I refreshed  the stored procedure , It started working.

Steps to refresh the Stored Procedure In Crystal reports .
1)          Open the Crystal reports Form .
2)          Open Field Explorer
3)          Expand the Database fields.
4)          Click on Database expert..  label.
5)          It opens the wizard , their Remove the Stored Procedure , that you have connected before and say ok.  
6)           Again Click on Database Export ...label , In the Wizard Select the same procedure , which was deleted before.
7)        Now  place all  the fields at appropriate place in the Crystal report form.

This will solve the Problem.