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)

nickd77376831
Level 2
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
martijn_123
Correct answer by
Level 3
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

0 Replies
martijn_123
Correct answer by
Level 3
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

nickd77376831
Level 2
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

Amit_Kumar
Community Advisor
Community Advisor

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