Why does SSRS Report Viewer control render error on some machines?

Question

Why does SSRS Report Viewer control render error on some machines?

Jerry VanDreumel 0

Using ReportViewerControl 150.1449.0 to render SSRS (rdl files) in a Delphi application

Click the report from the Delphi application and it opens the parameter box. Enter in parameters and it renders results on working machine.

Click the report from the Delphi application and it immediately generates the error.

Works on some machines but not others.

On the ones it does not work on the message received is "The following error occurred while attempting to load the report. Please try again or contact xxxx if this problem persists. An error occurred during local report processing."

Checked Event Viewer at time of occurrence and nothing renders there.

Was hoping application logs might render something but nothing there either.

Server 2022 using SQL 2019

Workstations Windows 11 and Windows 10 both using latest builds available. Some Windows 10 machines work and some Windows 11 machines work. Others get message provided earlier.

Microsoft Process Monitor used as well but not results.

0 comments

1 answer

Your answer

Answer 1

Michael Taylor 61,221

This is a general error meaning it couldn't load the report. There are any # of reasons why this could happen. Please post the relevant code that is failing. Specifically we're interested in what type of report you're using (server or local), how it is being loaded and how you're connecting data to it.

Capture the callstack at the point of failure. This will help narrow down if it is a problem finding a server-side report, report in a local path, issue getting data or rendering. Wrap the call in an exception handler and look at the exception details and any inner exceptions. The inner exceptions, if available, tend to provide the details of what the actual error is.

Jerry VanDreumel 0 Reputation points

2024-03-06T20:22:18.5+00:00
The file filename.rdl is called from the Delphi application.

On the machines this works on it opens a parameter box. You enter in the parameters. Click ok. If then opens a window showing the report and results. On the machines it does not work on when you click the menu item that error box pops up but that is all.

Thinking it is some type of conflict of components already there or something missing.

Did also do a Belarc report on a working and non-working machine but the comparisons did not show anything that bubbled to the top.

Not the developer here so don't have access to the code behind the GUI.
Michael Taylor 61,221 Reputation points

2024-03-06T21:07:14.0233333+00:00

Is the filename.rdl file actually on the machines that are having problems? Since you're going to be using LocalReport then the app has to set the report path to the local path to this file. If it is in the same directory (or a child directory) of the application then a relative path works otherwise the app would need to specify the full path.

Since the app is most likely using NuGet to get the package I'm assuming that MIcrosoft.ReportingServices.ReportViewerControl.Winforms and Microsoft.SqlServer.Types are in the application's executable directory. Can you confirm?

The best thing to do is wrap the call to create the local report in an exception handler block and get the exception details including the call stack and inner exception. This will generally reveal the problem pretty quickly.

Share via

Why does SSRS Report Viewer control render error on some machines?

1 answer

Your answer