The report viewer is blank when you try to view a report in the center page in Business Portal together with Microsoft Dynamics GP or Microsoft Dynamics SL

Cause 1

The report folder that stores reports that are published from Microsoft Dynamics GP or from Microsoft Dynamics SL is not shared.

The following users and groups must have full access to the report share:

• The Everyone group

• The Network Service user

• The Identity user for the Microsoft.BusinessPortal.Reports.FileService COM+ object

• The Identity user for the application pool that is used by Business Portal

See Resolution 1 in the "Resolution" section.

Cause 2

The identity user for the Microsoft.BusinessPortal.Reports.FileService COM+ object does not have full access to the Microsoft.BusinessPortal.Reports.FileService.dll file. See Resolution 2 in the "Resolution" section.

Cause 3

The location of the report share is not listed correctly in the ReportCatalog table. See Resolution 3 in the "Resolution" section.

Cause 4

The size of the Microsoft.BusinessPortal.Reports.FileService.tlb file is 0 kilobytes (KB). See Resolution 4 in the "Resolution" section.

Resolution 1

To share the report folder, and to add access to the report share for specific users and groups, follow these steps:

1. In Windows Explorer, right-click the folder that contains the reports that are published from Microsoft Dynamics GP or from Microsoft Dynamics SL. Then, click Properties.

2. Click the Sharing tab, click Share this Folder, and then click Permissions.

3. Click Add, type Everyone, click Check Names, and then click OK.

4. Click the Everyone entry.

5. In the Permissions for Everyone area, click to select the Full Control check box, and then click OK.

Note Repeat steps 3 through 5 for the other users and groups that are mentioned in the "Cause" section. The Network Service user is a local user. To determine the names of the other users and groups that you must add, see the "More Information" section.

Resolution 2

To add the correct access for the COM+ object, follow these steps:

1. In Windows Explorer, right-click the Microsoft.BusinessPortal.Reports.FileService.dll file, and then click Properties.
   
   Note By default, this file is located in the following path:

   C:\Inetpub\wwwroot\bin

2. Click the Security tab, click Add, click Locations, select the name of the Business Portal server, and then click OK.

3. Enter the name of the user, click Check Names, and then click OK.
   
   Note To determine the name of the identity user for the Microsoft.BusinessPortal.Reports.FileService COM+ object, see the "More Information" section.

4. Click the user name.

5. In the Permissions area, click to select the Full Control check box, and then click OK.

Resolution 3

To correct the location of the report share in the ReportCatalog table, run the following script against the company database.

SELECT  * FROM ReportCatalog

The Report_URL column must point to the report share. For example, if the Report.txt report is located in the C:\Reports folder on the BusinessPortalServer report server, the value in the Report_URL column must be the following value:

//BusinessPortalServer/Reports/Report.txt

Resolution 4

1. In Windows Explorer, locate the Microsoft.BusinessPortal.Reports.FileService.tlb file.
   
   Note By default, this file is located in the following folder:

   c:\inetpub\wwwroot\bin

2. If the file size is 0 KB, rename the file by using the following file name:

   Microsoft.BusinessPortal.Reports.FileService.tlbold

3. Click the following link to download a new Microsoft.BusinessPortal.Reports.FileService.tlb file:

   https://mbs.microsoft.com/fileexchange/?fileID=aab68342-5ba5-4084-adf0-44271a6f3141

4. Paste the file in the same folder in which the original Microsoft.BusinessPortal.Reports.FileService.tlb was located.