Skip to Content
May 04, 2018 at 02:10 PM

Crystal Reports: change sorting order based on a user selection


I am creating a report that needs to differentiate the order of month based on a user's selection. If a user selects "fiscal year", then the report needs to list the months starting from July. I tried to import this setting from the data source with SQL, but the report is not taking it.

I think I need to create a formula that starts something like:

If {?YearType} = "Fiscal" Then....

A screen shot of current report:


months.png (3.1 kB)