Dev Notes

Notes on Development with Microsoft Technologies

SQL Report Viewer Web Part Issue

Leave a comment

Recently, I was working with a colleague in a SharePoint 2013 On-Primesis environment to troubleshoot an issue when attempting to use the SQL Report View Web Part and a Content By Search or Search Results Web Part on the same page. To our surprise, the report viewer web part would not work with both web parts on the page.
The page made use of the query string to pass additional context for the Search Results Web Part and the SQL Report Viewer Web Part. When the SQL Report Viewer Web Part was placed on the page by itself, everything worked correctly. However, when either of the search web parts were placed on the page and configured, the report would stop loading. Upon opening developer tools for IE10, the following error was displayed:

SCRIPT5022: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near ‘ebPartEditing|false|<script type=’text/j’.

This appears to be related to the ASP.Net Update Panel. After a little digging in the web part configuration, we found a way to correct the issue.

Begin by opening the search web part and click on configure query.

contentbysearch-webpart-sqlreportviewer

The Build Your Query dialog will appear. Go to the Settings page and change the loading behavior to async.

sqlreportviewer-searchsettings

After this change was made, the sql report viewer web part began working properly again.

Advertisements

Author: Chris Quick

I have been a developer of web based solutions since early 2001 delivering solutions to a wide array of organizations using ASP, ASP.NET and SharePoint. I was introduced to SharePoint in 2003 when the consulting firm I worked for at the time introduced it into the workplace. I began working with MOSS 2007 as soon as Microsoft released the RTM version in November 2006. The platform was implemented at the organization I worked for in 2007 and went live in March of that year. I was tasked with the administration and ongoing development of the platform. I currently work as a SharePoint Architect with Artis Consulting, developing solutions for a wide variety of business problems. The goal of this blog is to share my discoveries developing solutions with SharePoint. I welcome your comments and feedback to any post -- and I welcome suggestions for future topics.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s