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

Crystal Reports: change sorting order based on a user selection

199 Views

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:

Attachments

months.png (3.1 kB)