Report not exporting with filtered results

  • 1
  • Problem
  • Updated 3 years ago
  • Acknowledged

I created an AdHoc View and report and added a filter with a ist of CCCIDs.  When I try to export the results to a CSV, I get the message below stating that I have over 20,000 rows when my report only has 36 rows.  How can I export my filtered data to a csv or excel file?

"The query for the report has been canceled because it returned more than 20,000 rows. You will have to modify the report to reduce the number of rows returned. "

Thank you in advance,

Mirna Duarte
Manager, District A&R
State Center CCD

Photo of Mirna Duarte

Mirna Duarte

  • 35 Posts
  • 0 Reply Likes

Posted 3 years ago

  • 1
Photo of Merrie Wales

Merrie Wales, Official Rep

  • 921 Posts
  • 50 Reply Likes
Mirna, 
What is the name of the report, and I can go take a look at it?
Photo of Mirna Duarte

Mirna Duarte

  • 35 Posts
  • 0 Reply Likes
md.Citizenship = 6 - Residency questions Report
Photo of Merrie Wales

Merrie Wales, Official Rep

  • 921 Posts
  • 50 Reply Likes
Mirna,
Just running the view, the data is multple pages long (perhaps we can have a meeting on-line to display what I see / you see).  The two filters in the report have no specific data filtering the view or report results...  This view/report has too much PII information for me to send a screen shot to you via email.  
Photo of Mirna Duarte

Mirna Duarte

  • 35 Posts
  • 0 Reply Likes

I just sent a screenshot of my filters to your email.  If you have time to meet this afternoon, that would be great!

Thank you

(Edited)
Photo of Merrie Wales

Merrie Wales, Official Rep

  • 921 Posts
  • 50 Reply Likes
Will continue this thread in a ZenDesk / Zoom meeting.