Forum Discussion
Multiple datasets for large paginated report
I have a very large report that utilized 33 separate data sets (all from the same source). This report generates 33 pages into a single PDF file. It takes over an hour to run, is there anyway to ma...
Thanks for the quick reply.
Each data set in the report populates a different table, the each table is a separate page of the report.
We used to create this in Crystal Reports but now are required to us Power BI
Better to have fewer datasets. You can have one dataset or a couple of datasets. Then for each table, filter down to the data you want. This applies to the paginated reports in the service: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-filter-report-builder-and-ssrs?view=sql-server-ver16 Or at the dataset level: https://www.mssqltips.com/sqlservertip/2597/dataset-and-tablix-filtering-in-sql-server-reporting-services/
