DevOps, CI/CD and Automation

i have developed a number of complex reports with several queries and formula objects, all running successfully and converting to other formats accuratelly.

i have report of Accounts Receivables, a complex one, running near about 10 queries and 7 formula column database functions to calculate values for each row return, this report works accuratelly and converts to other formats easily but takes full 60 to 70 seconds to run the report.

management asked me to enhance the performace of this report,

i had worked out and reduce the number of queries and formula columsn to one single query with 5 nested(union queries) queries. execution times reduces to 3 to 5 seconds with accuracy.

Report displays correctelly but give an error "Rep-0999 Unimplemented Error" whenver we converts it to pdf or other sources.

While other complex reports were still converting successfully.

Help me out of this problem,.... im hands up at this situation.

bye