Select the product you need help with

How to delete demo reports in Business Portal together with Microsoft Dynamics SL

Article ID: 913818 - View products that this article applies to.

INTRODUCTION

This article discusses how to delete demo reports in Business Portal together with Microsoft Dynamics SL and with Microsoft Business Solutions - Solomon.

Back to the top | Give Feedback

MORE INFORMATION

To delete a demo report in Business Portal, follow these steps:

In Business Portal, click Site Settings, click Application Settings, click Reports, and then click Report Scheduler.
In the Report List area, click the down arrow that is next to Report, and then click Request.
Highlight the demo reports, and then click Delete.
Each report has a template associated with it. To remove the template for the demo reports, you have to manually run the following statement against the system database:
DELETE Template where Descr like ‘%Business Portal%’

Note Sometimes the demo report is not removed correctly. In this situation, view the following table for a list of the databases and the tables that contain references to reports in Business Portal. You can use the information in this table to manually remove the demo reports.

Collapse this tableExpand this table

Databases	Tables
Application Database	Report Catalog
System Database	ReportRequest, AppSrvRequest, Template

To remove the demo reports manually, use one of the following methods depending on the SQL Server tool that you are using.

Method 1: SQL Server Enterprise Manager

Click Start, click All Programs, click Microsoft SQL Server, and then click Enterprise Manager.
Expand the name of the SQL Server, expand Databases, expand the specific database, click Tables, right-click the specific table, point to Open Table, and then click Return all rows.
Right-click the records for the report that you want to delete, and then click Delete.

Method 2: SQL Server Management Studio

Click Start, click All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
In the Connect to Server window, follow these steps:
1. In the Server name box, click the name of the SQL Server.
2. In the Authentication box, click SQL Server Authentication.
3. In the Login box, type sa.
4. In the Password box, type the password for the sa user, and then click Connect.
In the Object Explorer area, expand the name of the SQL Server, expand Databases, expand the specific database, expand Tables, right-click the specific table, and then click Open Table.
Right-click the records for the report that you want to delete, and then click Delete.