Currently I have a report that is based on an income statement. The report's purpose is to show by revenue by accounting period showing various other pieces of information (i.e. custom fields for revenue type, revenue category etc.). The problem I have is that the report takes 20-30 minutes to run. Even after I run it I have to manipulate it to get it into the format for flash revenue report that is delivered to various people. The format example of the report data pull is
| Financial Row | Customer Source | Business Unit | Revenue Type | Item | Jul 2017 | Aug 2017 | Sep 2017 | Oct 2017 | Nov 2017 | Dec 2017 | Jan 2018 | Feb 2018 | Mar 2018 | Apr 2018 | May 2018 | Jun 2018 | Jul 2018 | Total |
| 40001 - Plan Revenue | Direct | - No Business Unit - | Recurring | Unassigned | $4,124 | $4,124 | $4,124 | $4,124 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $16,495 |
I also have a saved search which provides me with all the revenue transactions (and the pieces of information mentioned earlier). It runs in about 30 seconds or less. It only shows 1 month of data and not 13 months.
I need a report that will run much faster than 20-30 minutes and was wondering if it possible to create a summary saved search report which would accomplish the same thing as the revenue report I use to create flash but run much faster and potentially allow me to use formulas which would to the manual manipulation I currently do to the revenue report. I am not married to the saved search idea. I just need to get a report in far less time.
Thanks