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


Symptoms


When you use Business Portal for Microsoft Dynamics GP, for Microsoft Business Solutions - Great Plains, or for Microsoft Dynamics SL, the report viewer is blank when you click a report name that appears in the center page.

Cause


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


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:
  4. Paste the file in the same folder in which the original Microsoft.BusinessPortal.Reports.FileService.tlb was located.

More Information


To determine the identity user for the Microsoft.BusinessPortal.Reports.FileService COM+ object, follow these steps:
  1. Click Start, click Administrative Tools, and then click Component Services.
  2. Expand Component Services, expand Computers, expand My Computer, and then expand COM+ Applications.
  3. Right-click Microsoft.BusinessPortal.Reports.FileService, click Properties, and then click the Identity tab.
To determine the identity user for the application pool that is used by Business Portal, follow these steps:
  1. Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
  2. Expand the computer name, and then expand Application Pools.
  3. Locate the application pool that you are using for Business Portal.
  4. Right-click the application pool, click Properties, and then click Identity.

References


For more information about troubleshooting steps to use when FRx reports do not display in Business Portal, click the following article number to view the article in the Microsoft Knowledge Base:

861754 You cannot view FRx Reports in Business Portal in Solomon and Great Plains

861754