Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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

Level 10

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