Constant loading when searching a table
Hi, I am hoping there is something I can do to solve this but it seems that when I perform a search in my largest tables the data is continuously "Loading...." and it never seems to find anything. I c...
Forum Discussion
I am experiencing this problem as well. I am searching <500 records with approx. 5 columns in the report, and I can't get the search to complete.
Jeff,
I had a somewhat similar issue where when I would launch some of my reports on a certain table it would churn on the clock for a long time (although it usually finally rendered back results) and others would come back almost immediately.
In the end I figured out that it was due to having unusual dates in one of my datetime fields for a couple of rows. We had loaded data via an import and had inadvertently had one row load the datetime field with a year of 1616 and one with a year of 1619. Even though these are technically valid dates in QB anytime a report happened to include 1 of these 2 rows it would take a very long time to render. Once I corrected the dates everything was fine with report retrieval.
This might not be your situation but it might be helpful to look at the data in any date fields you have and see if you have something similar.
------------------------------
Audrey O
------------------------------
I had a somewhat similar issue where when I would launch some of my reports on a certain table it would churn on the clock for a long time (although it usually finally rendered back results) and others would come back almost immediately.
In the end I figured out that it was due to having unusual dates in one of my datetime fields for a couple of rows. We had loaded data via an import and had inadvertently had one row load the datetime field with a year of 1616 and one with a year of 1619. Even though these are technically valid dates in QB anytime a report happened to include 1 of these 2 rows it would take a very long time to render. Once I corrected the dates everything was fine with report retrieval.
This might not be your situation but it might be helpful to look at the data in any date fields you have and see if you have something similar.
------------------------------
Audrey O
------------------------------