Ad Hoc: how to include all results pages in a scheduled report (ie >50k rows) | Community
Skip to main content
B
BrianBoru
Level 2
January 21, 2016
Solved

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

  • January 21, 2016
  • 3 replies
  • 1757 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by martijn_123

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

3 replies

martijn_123
martijn_123Accepted solution
Level 3
January 21, 2016

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

B
BrianBoruAuthor
Level 2
January 21, 2016

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
Amit_Kumar
Level 10
January 21, 2016

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

Terms & ConditionsAccessibility statement

Loading footer...