The table 'ReRep1900' could not be found when running Demographical and Statistical report

When running the Demographical and Summary report with the Number of Constituents selected in the Limit the Results to drop down on the Format>Detail tab the following error message occurs.
The table 'ReRep1900' could not be found.
Error in File ReRep1900L
{66E86D15-D35C-45FE-9DEE-B44DDBB2E89D}.rpt
The table could not be found. (997)

We have evaluated this issue and have determined it will not be addressed in the program in its current state. This message can be returned in this report when filtering by other gift specific fields when you limit the report by "Number of constituents" when "Number of constituents isn't included as the column". Number of constituents is a arbitrary field when breaking down the report by a gift filter and would not be included in the report results by default. To configure the report to limit by number of constituents when summarizing by a gift field, users can include "Number of constituents" as a column on the Fields tab.

Steps to Duplicate

1. Open RE
2. Click Reports>Demographic and Statistical Reports>Statistical reports
3. Click New
4. Click Tab 2: Fields
5. Select Months in a year from the "fields to use" drop down.
6. Click Tab 7: Format>Detail
7. Mark the Limit Report Results box
8. Select Number of constituents from the "Limit the Results to" drop down
9. Click Preview
10. Error message
The table 'ReRep1900' could not be found.
Error in File ReRep1900L
{66E86D15-D35C-45FE-9DEE-B44DDBB2E89D}.rpt
The table could not be found. (997)

Environment

 Raiser's Edge
 7.96

Was this article helpful?