Sage Intelligence Financial Report giving a timeout error

SOLVED

Hi

I am trying to generate a report using the Financial Report Designer.

I have copied the Report to another folder to unlock the edit function.

It gives me a Timeout error.when running the Report.

The Chart of accounts is in excess of 15,000 accounts.

I did change the Timeout settings in SQL, but I get the same error.

I copied the company excluding all transactions, thinking that it would run, but the same error.

So I deleted about 5,000 accounts.

Then I was able to run the report.

Unfortunately I cannot delete the accounts from the live database because all are needed.

How can I get the report to run with all accounts and without getting a timeout error.

The Ledger is the Standard structure with Branch and Departments. as well as Master And Sub Accounts.

Regards,

Satchu Archary

Amega Support Services