Tuesday, September 6, 2011

Could not load file or assembly 'Microsoft.ReportViewer.WinForms' after upgrading to Integration Manager 2010

When trying to run an integration in GP2010 (after just upgrading from 9.0), you may receive the following error:

Log Report Failure
Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

The latest versions of Integration Manager now incorporate the ReportViewer Control for displaying the different reports generated by the application.

If you receive the above error, install the ReportViewer Redistributable component from one of the following locations:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=21916 (Visual Studio 2005 components)


http://www.microsoft.com/download/en/details.aspx?id=6576 (Visual Studio 2008 components)
The latter will work just fine with Microsoft Dynamics GP 2010 or 2010 R2.

It is also recommended to install the 2007 Office System Driver Data Connectivity Components, which can be downloaded from:


Microsoft Access Database Engine 2010 Redistributable, which can be downloaded from:

Keep in mind that the above are not a substitute for Microsoft Office and are just intended to facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
Once done, reboot the machine.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC


Ralph Wahlert said...

Thanks. This saved the day.

Mariano Gomez said...

Glad to know this was able to help.


Anonymous said...

can u help me with this pls csharp reportviewer not work after published the application

************** Exception Text **************
System.Data.OleDb.OleDbException: Could not find file 'C:\Users\Nati\AppData\Local\Apps\2.0\Data\Z40CHXJ7.REG\XZN08VM0.PQ0\comp..tion_7f23c22ac8729f36_0001.0000_a3013bb934afc1b1\Data\ePatientRecordSystem.accdb'.

Unknown said...

Hi Anonymous,

Did you find the solution to your problem. I am also getting the same error of database not found, when I run my reports in the application after installing it on my machine. Can anyone please help. Thx much.


Unknown said...

Thanks.... because of this i have solved my problem

Dan Roach said...

Hey Mariano. There is another option if users do not want to load the fix. The log report destination on the integration properties page can be set to 'File' instead of database and individual files are created for the logs and viewable. They are just text so not as nice as the report viewer but a solid work around in a secured environment.