Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Ad Hoc: how to include all results pages in a scheduled report (ie >50k rows)

Avatar

Level 2

I have many reports >50k rows.

When I schedule reports, only page 1 (1st 50k rows) is included.

How can I get all pages included in the report?

I've figured out a workaround, but it's cumbersome and I'd prefer a real solution.

nick

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi Nick,

 

I don't think it is possible in Ad Hoc. Can't you make the report in Data Warehouse or Report Builder? Report Builder has similar restrictions but it is easier to extract all the rows that you need (e.g. 1-50.000, 50.001-100.000, etc..).

 

Cheers,

Martijn

View solution in original post

3 Replies

Avatar

Correct answer by
Level 3

Hi Nick,

 

I don't think it is possible in Ad Hoc. Can't you make the report in Data Warehouse or Report Builder? Report Builder has similar restrictions but it is easier to extract all the rows that you need (e.g. 1-50.000, 50.001-100.000, etc..).

 

Cheers,

Martijn

Avatar

Level 2

Hi Martijn,

Thanks for the help.  I had problems in the past with huge reports in Report Builder, but I can try again.  

I've tried pulling the data via Data Warehouse but have yet to receive a report.  I suspect there's a problem somewhere, and I need to try to find our admins and get it sorted out.

nick

Avatar

Community Advisor

As suggested by Martijn Report builder will solve your problem i verified this with my reports.