How to change drilldown order

[bharathazp]

Hello, I have created a report with multiple drill down options, now i would like to change the order of the drill down. Need to bring up few drill down reports. Can someone guide me with this. Thanks in advance.

[Badal Khojare]

Hi @bharathazp ,

Can you provide a screenshot of your drilldown report and changes you want.

[mister_mentor]

@bharathazp 

I'm not sure this is possible on the platform. In the report editing area there is nothing that allows to change the order. On the sys_report table I did some testing in my PDI. There is a "report_drilldown" field that reference the report that drills down to the next level. So I added a few test drilldowns to a report and used background scripts to change the report drilldown structure. It allowed me to do it but it messed up everything. I couldn't get the reports to load at all and I couldn't even navigate to the sys_report table any more. I had to resort to deleting the reports through background scripts before I could even get back to the table.

Good luck with it! I know I didn't provide an answer but I at least wanted to provide you with one path to NOT take. 🙂