We have a report (ex) that uses a sub-report, and a good bit of logic in the main report to go through APPAYMENT records. When running from my desktop, 12k records are selected, and appropriately reported in approximately one minute. When I publish the report to LBI and run it from a dashboard, it takes in excess of 20 minutes to complete. This is not using OLEDB - it is using an Oracle DB connection. Can anyone provide any feedback on improving the performance through LBI? I understand that it might take a little longer to run with LBI in the middle, but the 20+ minute difference is a bit confounding.
Output is Excel, as much of the logic includes color coding based on vendor payment balances.
