Maximum elapsed time crossed and showing Interaction limit exceeded 30s
Hi all,
I am working in Production Support.
There is some problem while report definiton is executing with certain search criteria.
This particular report definition has 2 sub-reports and one drill down report.
when it executes at run time will execute all the sub-reports ot will it execute main report?
If at all it executes main report,here the main report is having very simple select query.
if not,the quey is very complex which is 2 left outer joins in single query on single work table.
Is it gud to execute report query's on Work table?
***Updated by moderator: Lochan to add Categories***