BI reports

Question

A workstation generating the BI reports has been upgraded with a new laptop. Where do I go to establish the link with pervasive in order to generate the reports again

We Do Software · Answer

Hi Ilona Jacobs 
 Please follow the steps below to add the company database manually to your Sage Intelligence 
 Deleting the existing database: 
 Go to View...Intelligence Reporting...Launch...Report Manager 
 Right click on Home under the File menu and a screen as shown below will appear 
 Select PVS.SQL DB Manager from the list 
 Enter the server name (please note that on Pervasive Workgroup it will be the computer name of the workstation and on a Client/Server Installation it will be the computer name of the Server) 
 Double click on the Computer name. 
 Locate the database for the company you want to run your report for 
 Right Click on this and left click on delete. 
 
 Creating a Database using Report Manager: 
 
 Right click on the server name and select Add Database Name as shown below 
 Enter the database name 
 The database name should start with PAS19 and then the company folder name e.g. if your company folder is DEMO16, you should enter the database name as PAS19DEMO16 or PAS18DEMO16 depending on the Pastel version you are running. 
 Select the company folder when prompted to select the DDF File Path as shown below and click OK 
 Select the company folder when prompted to select the DDF File Path as shown below and click OK 
 The company will start showing on the databases as shown below. Click on Verify DDF File Path and Verify DAT File Path and ensure that you get the message OK 
 Once that is done, please run your reports again. 
 if my answer does help: please let me know by clicking on verify answer

Shazi · Answer

Hi there Ilona Jacobs 
 How did it go with the fix suggested? 
 If it did help you please click on verify answer. 
 Shazi

Sage 50cloud Pastel

BI reports

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING