It's probably my "fault" for having too many if, then statements. :)
But, are there any good ways to reduce runtime for a report?
I have a Consolidating Trial Balance report that is taking more than eight minutes to generate upon clicking "Run".
Like I said, I do have many "copied" if, then statements.
Also, it's pulling data from multiple companies and performing other calculations.
I'm simply wondering if there is something that I can fix, prior to showing a report to an end user.