We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
Incomplete report using MS Report Viewer 12 with SSRS 2017 from WebFarm
3 replies
Last post Sep 07, 2018 05:46 AM by DEVSupport_MSFT
Last post Sep 07, 2018 05:46 AM by DEVSupport_MSFT
Member
7 Points
63 Posts
Incomplete report using MS Report Viewer 12 with SSRS 2017 from WebFarm
Sep 04, 2018 08:40 PM|jwbutler23113|LINK
Project: Visual Studio 2017 - Web Application compiled using .Net 4.6.2 with Async SQL session state to a SQL Server 2017 instance
WebFarm Framwork configuration - using shared content, centralized certificates, ARR with Affinity set to Client
1 - Windows Server 2012 gateway server
4 - Windows Server 2012 content servers
3 - Windows Server 2012 - SQL Report Servers using custom load balancing
When I deploy the application to a single server the reports render without issue but when I deploy it to the web farm the report viewer only renders the supplied parameters but any dynamic options (drop down lists) are disabled and the drop down button images are missing.
Star
9831 Points
3120 Posts
Re: Incomplete report using MS Report Viewer 12 with SSRS 2017 from WebFarm
Sep 05, 2018 05:35 AM|Brando ZWZ|LINK
Hi jwbutler23113,
According to your description, seems that your site doesn't load the css or the image well.
Could you please provide the log of css or images when accessing via the url?
You could see it from browser's F12 develop tool like below:
Best Regards,
Brando
Member
7 Points
63 Posts
Re: Incomplete report using MS Report Viewer 12 with SSRS 2017 from WebFarm
Sep 05, 2018 03:02 PM|jwbutler23113|LINK
The images come from Microsoft.Reporting.WebForms.dll and this library is installed on every server in the web farm and on the file server where the shared content is stored.
<input type="image" name="rv$ctl05$ctl00$Last$ctl00$ctl01" id="rv_ctl05_ctl00_Last_ctl00_ctl01" title="Last Page" src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=12.0.2402.15&Name=Microsoft.Reporting.WebForms.Icons.FirstPage.gif" alt="Last Page" style="border-style:None;height:16px;width:16px;display:none;" />
Member
70 Points
34 Posts
Re: Incomplete report using MS Report Viewer 12 with SSRS 2017 from WebFarm
Sep 07, 2018 05:46 AM|DEVSupport_MSFT|LINK
>When I deploy the application to a single server the reports render without issue but when I deploy it to the web farm the report viewer only renders the supplied parameters but any dynamic options (drop down lists) are disabled and the drop down button images are missing.
Web farm also has its nodes. I would suggest you test single node to check whether it will work on single node. It will help you to exclude a lot of issues. There is no detailed error information from your description. I would suggest you use IIS log and IIS FREB tracing to help identity this type issue (check on node server):
IIS log: PATH: %SystemDrive%\inetpub\logs\LogFiles
FREB log: https://blogs.msdn.microsoft.com/amol/2009/04/01/freb-failed-requests-tracing-in-iis-7/
>The images come from Microsoft.Reporting.WebForms.dll and this library is installed on every server in the web farm and on the file server where the shared content is stored.
Please also check the connection between file server and web farm nodes.