Database reports work just like any other LiveFlow report, with two major differences:
They support reports with up to 100,000 rows *
In any of your own columns, your formulas will be automatically copied from the first cell to all other rows of the report – no more copy/pasting when new rows are added!
* QuickBooks itself caps reports at a total of 400,000 cells, so a report with 100,000 rows implies that it has four columns: a report with eight columns would allow 50,000 rows, etc.
When should I use them?
If you work with large reports from QuickBooks, and you use those reports primarily as a "database", i.e., you are mostly interested in deriving data from these reports quickly and reliably
If you find yourself repeatedly copying formulas to new rows, or often reaching for
ARRAYFORMULAIf you are using our Live Functions to load transaction data, you should try these instead
If you have been loading large reports (1,000+ rows) using LiveFlow, but you've been frustrated with the speed or reliability of refreshing those reports, you should try enabling this option
What are the drawbacks?
You should not insert your own rows in these reports, because all rows are cleared and replaced during refresh
These reports don't include links back to QuickBooks online, so they won't support Drill Down
We don't apply padding for indentation in the first column, and we don't automatically assign collapsible row groups either
How can I use them?
The option will be enabled by default for new detailed reports like General Ledger, Transaction Detail and Profit and Loss Detail
You can toggle the option from the Advanced settings on both new and existing reports
You can spot a report where the option is enabled from the blue column headers