Hi James, I need some help from you on solving a problem in Crystal to SSRS conversion. I am trying to convert a Crystal Report to an SSRS Report.In the Crystal Report the Data is filtered using a Parameter which can accept Multiple Range Values.In order to achieve the same feature in SSRS I wrote a small Custom Code in VB. This Function will accept the Field and the Parameter as Strings with multiple ranges separated by commas and will return a Boolean True if the field satisfies any one of the given ranges.Otherwise it will pass a Boolean false. So only the Rows with True as return value are passed forward. I used the above condition in the filter clause of the Datasets not in the where clause unlike Crystal.Now I face a new Problem. In the Crystal report there are 3 Groups and the Crystal Query has an Order by clause on these 3 Groups. So In crystal after the where clause the Sorting is taking place. Now I tried to do the same in SSRS and implemented the Order By clause in the SSRS Query.But the outputs are not matching. One reason may be that ,In Crystal the Sorting of data in groups is done after filtering but in SSRS Sorting is done before the filtering. Is there an alternative or any work around that you can suggest me to get the same as of Crystal. Please help me.

In SSRS there is no support to ranged parameter, but there is a workaround. You can split a rangedParameter into two single value parameter, one is rangedParameterStart, the other rangedParameterEnd, in doing so, you can tweak the filter in the query level. This probably solves your problem. By the way, if you choose Crystal Migration Services, ranged parameter will automatically be converted into two single value parameters. http://www.crystalmigrater.com/Default.aspx