CODEWITHSUNDEEP
sqlreporting-services
Garry B
Garry B

Reputation: 211

SSRS 2016 Report Not showing multi pages

I have been made aware of an issue with one of our SSRS reports. In Dev and Test when the report is executed you get the results 1 of 2?

Dev/Test: enter image description here

And when I run the report in production I get 0 of 0.

Prod: enter image description here

I am using the same report parameters in each environment.

I have compared the RDL XML and the ReportServer.config from each environment and they are all the same.

The SSRS and SQL versions are all the same. SQL 2016 SP2 CU11

Does anyone have any suggestions on what might be causing this.

As a hack, I was able to do a find for any random word and when the result came back with nothing found then the page numbers and navigation worked as expected. :( enter image description here

Upvotes: 1

Views: 397

Answers (1)

Garry B
Garry B

Reputation: 211

ReportServerTempDB was in RCSI mode and that was causing the issue.

Upvotes: 1

Related Questions