Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago

Filter Report by Record ID#

I have a table with near 15,000 records and would like to export all of the records. With the 5,000 record limitation for export, I thought a good idea would be to filter 3 separate reports by Record ID#; i.e. the first report would be filtered for Record ID#'s 1 to 5,000, the second report 5,001 to 10,000 and the third report 10,001 to 15,000.

The reports come up blank and I do not understand why.

I tried to also include a formula numeric field with the [Record ID#] as the body of the formula. The numeric value compiles and displays correctly, but will not filter the reports.


Please Help!
Data import and export
Formulas and functions
reports and charts
  • JordanMcAlister's avatar
    JordanMcAlister
    Qrew Captain
    6 years ago
    Can you create a report with the Record ID# as one of the columns and sort by Record ID# from low to high to confirm your lowest Record ID# is within your filter range. I have a table with around 20,000 records in it, and when I tried to replicate the same thing and noticed the same error, so I sorted a basic report with the RID# and noticed my lowest RID# starts at 13,379 for whatever reason.
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    Thanks for taking the time Jordan, my lowest record ID was 49641. I apparently deleted many, many records while getting the table set up just right and failed to take this in account when creating the report filters.