Last post Apr 25, 2014 03:24 AM by Michelle Ge - MSFT
Apr 24, 2014 05:45 AM|jainbhaiiit|LINK
Hi, I am facing a straing issue in SSRS, I Have a report which is having multiple pages
Reports loads successfully
On clicking Priview report loads
Report has 67 pages
pageing works fine till page 12
Trying to load page 13 , SSRS crashes
Trying to load page 14 , works fine.
I cahnged the SP to eturn only page 13s data.. hence now Report is having only one page ..
Report load successfully, Preview successful, Export successful.
Again I chaned the SP to return Page 12, 13 ,14 data --> now Report has 3 pages 1, 2, 3
--> Report lodes successfully, Preview Page 1 Success, Preview Page 2 --> SSRS crash --> Reopen the solution --> Preview Page 2 successful, --> Export to Excel --> SSRS crash.
Please help me out in this strange issue.
Apr 25, 2014 03:24 AM|Michelle Ge - MSFT|LINK
According to your description, I suggest you going to review the report service logs. Try to see where exactly this server crashed. Sometimes you get a clue on what exactly is the issue in the logs.
Also you can try to install SQL Server 2008 R2 SP2, then the issue may be resolved. You can try to run the Visual Studio in safe mode, please refer to the link below to run steps by steps:
Hope it's useful for you.