'Is it possible to split very large RDLs at a specific breakpoint?

I have a very large RDL that prints to a PDF. The generated PDF results in thousands of pages and it's not really possible to reduce the result set.

I've tried many different methods for optimizing the PDF output such as reducing unnecessary formatting, removing all images, using embedded PDF fonts, but my report still takes a very long time to process.

If each one of my records carries an ID beginning with A-Z, is it possible to have the RDL itself trigger multiple child RDLs, such that something like all "A" results would be produced, all "B" results would be produced and so on and so forth?

reporting-servicesssrs-2012ssrs-tablixrdl


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Report wont run when using OLE DB connection

ORA 01797- operator must be followed by any or all

SSRS fixed position of tablix in body of the document. Visual Studio

A timeout (30000 milliseconds) was reached while waiting for a transaction response from the ReportServer service

SSRS - Disabling export options (eg. PDF) for individual reports

Tabbed Reports in SSRS

SQL server report error - "rsInternalError"

Strange issue in SSRS 2016. I am unable to select parameters or run the report intermittently, it works fine most of the time

SSRS Reporting in Blazor

Setting a list of several values to one SSRS parameter in "Available values"

SSRS Tablix border size inconsistent

The version of the report server database is either in a format that is not valid, or it cannot be read

Reporting Services - show multiple values for a column horizontally rather than vertically

SSRS Data Driven File share account - impersonation error

SSRS avoid WHERE clause if select all is selected