Filter Report by Record ID#

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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!
Photo of Adam Keever

Adam Keever

  • 2,400 Points 2k badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Jordan McAlister

Jordan McAlister

  • 1,522 Points 1k badge 2x thumb
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.
Photo of Adam Keever

Adam Keever

  • 2,400 Points 2k badge 2x thumb
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.