CODEWITHSUNDEEP
reporting-servicesssrs-tablix
radders
radders

Reputation: 923

Report not showing all data and not paginating

I've returned to our reports collection after a couple of years away, and added a new report which has a simple tablix containing a few columns, but many rows from the dataset.

The problem is, the report (in Preview in VS, and when run on the Report Server) only shows some of the rows returned by the dataset, and doesn't enable the page navigation icons in order to scroll through the data to access the rest.

Where do I find the settings which control these things, please?

UPDATE: Looking at some pre-existing reports, it seem that these exhibit the same problem - it would appear that SSRS can only display about 5,000 rows regardless of how many the dataset contains.

Upvotes: 0

Views: 694

Answers (1)

radders
radders

Reputation: 923

There is a 'hidden' setting in the XML code (not available via the UI AFAIK) called InteractiveHeight. Removing this line resulted in the paging starting to work

Upvotes: 1

Related Questions