Thankyou for your responses.
@Bo_Chief: The reports are in Interactive mode so it is Java.
@Michael : What is quick display mode? How do I try that?
Here is my analysis so far :-
I moved the report to one of my test environment where the report query takes 15 seconds due to low data volume of around 30,000 rows.
When I refresh this report , it took 1 minute 20 seconds as processing and another 1 minute 10 seconds as Retreiving/Decoding time .
Thanks to the below wonderful forum , I switched off the auto height /auto width property for the cells and the retreivign/decoding time came to 1 second. Thats awesome!! So this will take away 3-4 minutes for this report in Production.
https://bobj-board.org/t/155190
Now my next research is for the processing time . 1 minute 20 seconds is crazy for 15 seconds query. May be some universe or cmc level setting?
anair_bo 
(BOB member since 2006-12-05)