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

[John]

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:

Powerful Reports (Using any SQL)

Hi everybody, I’m back to sharing tools I create for myself with the community. I could not find a reporting module that was powerful enough for advanced SQL users that want to use any SQL to build reports, so I have started building one. If I may say so myself I think it is pretty powerful and yet very easy to use. It also allows admins to link reports directly to modules or even records inside the CRM that make it super friendly for users that need to use the reports. It also uses caching…

How to add other charts in Report Charts, For ex. Line Chart, Bubble Chart, Gauge chart, Funnel Chart etc.

Hello Suite CRM support, Can you please help me to add new chart type in Report for attracting view of Reports Dashlets. I want add gauge chart , bubble , funnel chart in suite crm . What step i follow to get done this task. Please help, i am stuck. Thanks in advance Rahul Gupta

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

SQL Query

Sapiens.BI Basic - Analytic Reporting | SuiteCRM Module

Let us know if you have any questions!