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 1The 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
Cause 2The 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 3The location of the report share is not listed correctly in the ReportCatalog table. See Resolution 3 in the "Resolution" section.
Cause 4The size of the Microsoft.BusinessPortal.Reports.FileService.tlb file is 0 kilobytes (KB). See Resolution 4 in the "Resolution" section.
Resolution 1To share the report folder, and to add access to the report share for specific users and groups, follow these steps:
- 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.
- Click the Sharing tab, click Share this Folder, and then click Permissions.
- Click Add, type Everyone, click Check Names, and then click OK.
- Click the Everyone entry.
- In the Permissions for Everyone area, click to select the Full Control check box, and then click OK.
Resolution 2To add the correct access for the COM+ object, follow these steps:
- 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
- Click the Security tab, click Add, click Locations, select the name of the Business Portal server, and then click OK.
- 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.
- Click the user name.
- In the Permissions area, click to select the Full Control check box, and then click OK.
Resolution 3To correct the location of the report share in the ReportCatalog table, run the following script against the company database.
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:
SELECT * FROM ReportCatalog
- 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
- If the file size is 0 KB, rename the file by using the following file name: Microsoft.BusinessPortal.Reports.FileService.tlbold
- Click the following link to download a new Microsoft.BusinessPortal.Reports.FileService.tlb file:
- Paste the file in the same folder in which the original Microsoft.BusinessPortal.Reports.FileService.tlb was located.
To determine the identity user for the Microsoft.BusinessPortal.Reports.FileService COM+ object, follow these steps:
- Click Start, click Administrative Tools, and then click Component Services.
- Expand Component Services, expand Computers, expand My Computer, and then expand COM+ Applications.
- Right-click Microsoft.BusinessPortal.Reports.FileService, click Properties, and then click the Identity tab.
- Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.
- Expand the computer name, and then expand Application Pools.
- Locate the application pool that you are using for Business Portal.
- Right-click the application pool, click Properties, and then click Identity.
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 Plains861754