What is the best way to make a report that pulls from a very large sheet (14K+ lines)?

Rachel Apostol

My source sheet is 14K+ lines and counting. Reports are limited to 2500 lines. Even when I have broken this data down by the quarter, this report is too large to even display all the data. What is the best way to support this?

Genevieve P.

Hi @Rachel Apostol

Do you have Grouping applied to your Report? Grouping will limit what the report can show:

However if you aren't using Grouping, the Report will allow you to page through all the data, as Paul mentioned:

Cheers,

Genevieve

Genevieve P.

Hi @Rachel Apostol

I would either remove the Grouping and simply Sort by the values you're grouping by so you can manually page through the data, or set up multiple, grouped Reports, splitting up your information into smaller chunks (such as date ranges or specific grouped values).

Paul Newcome

Reports are not limited to 2,500 lines. If you scroll to the bottom of the report, there should be a link to go to the next page.

Rachel Apostol

There is no link at the bottom of the page. I have checked it from my screen and two other colleagues' screens; none of us see a link.

Genevieve P.

Hi @Rachel Apostol

Do you have Grouping applied to your Report? Grouping will limit what the report can show:

However if you aren't using Grouping, the Report will allow you to page through all the data, as Paul mentioned:

Cheers,

Genevieve

Rachel Apostol

I do have grouping which is needed for this report; what is another way to pull a report with this large of a set. That message of 2500 grouping does not appear anymore with the filters I have selected but the report is still limited.

Genevieve P.

Hi @Rachel Apostol

I would either remove the Grouping and simply Sort by the values you're grouping by so you can manually page through the data, or set up multiple, grouped Reports, splitting up your information into smaller chunks (such as date ranges or specific grouped values).

Paul Newcome

@Genevieve P. Thank you. My next question was going to be about grouping but I got tied up with work.