👋🏾 Looking to join our SuiteCRM Community Working Group? 💌 Open invitation throughout January. Check out all the details here 👈

I would like to show reports status on custom order in suitecrm

I would like to show reports status on custom order in suitecrm. By default, there are 2 options like ascending and decending. But my client wants the lead status into custom order. Please refer below screenshot.

1 Like

Hey there

Are you still looking for solutions for this?


I don’t believe the CRM has an OOTB way to enforce a specific order on the Chart Axes, i’m afraid


Perhaps a workaround could be to change the labels of the Statuses?
(ie: “New” → “1 - New”, “Get the Watch” → “2 - Get the Watch”)
Then, theoretically, you should be able to sort this alphabetically and order the axis in this way?


Otherwise, you may be able to create a totally custom report via SQL


I haven’t attempted this myself, but there are a few threads where users note varying levels of success in this:

Or perhaps, some third party add-ons may assist?:

Let us know if you have any questions!