Prepared Report issue

The issue i am facing with prepared report is that, when i run the same query through database the result gets generated, but when i do it from prepared report, the output takes either long or gets stuck in queue. can anyone help

@prarup_acharya Please check your rq job and scheduler is active or not and prepared report list report status

scheduler is active, it shows up on rq job and prepared list report as well. it gets stuck as queued or started on rq job