Business Insights Reporter Wizard shows no Templates

Written by Todd Martin on .

Sage 100 has a tool called Business Insights Reporter. It that can be found by going to Modules | Business Insights | Reporter in Sage 100. This tool has a step by step Wizard to walk you through creating reports. If there is no existing reports to list, the Wizard will start automatically. Otherwise, you would see a list of existing reports and a button in the bottom left to create a new report using the Wizard.

Business Insights Reporter Wizard Start
The Wizard is great for quickly creating a report using a template and views, which are multiple tables linked together for speed and ease of use. The Business Insights Reporter Wizard walks you through the process of creating the report and place it on the custom reports folder for the module you wish to have the report run from. 

What if your Business Insights Reporter Wizard doesn't show any templates in the list?

Business Insights Reporter Wizard Missing Template
In this example you can see that the list under Template is blank. By Default the list should show three templates. It should have Landscape, Portrait and Shipping Labels. When you click on any one of the templates it should show to the right the preview of the template.

What to know how to add your own templates? 

Typically, it is after upgrading when the templates do not show. This will happen when you don't convert your crystal reports located in the mas90/Reports/BIReporter/Templates folder. In this folder you will see the .rtp template file with the .bmp preview image.

BIR Template FolderEach of the .rpt files listed in this folder must be on updated to be on the same level as your Sage 100 system. In most cases you would run the MASCRCW.EXE file to update these. Once the Crystal Reports Conversion program is done converting the reports in this folder, the issue should be fixed. An alternative way to fix this issue is to open the Crystal Report and edit the Summary info manually. 

If the report is updated manually, you must make sure that all the fields and tables are changed to the new version of Sage 100. Otherwise the report output may not be as expected.
To edit the Summary Info, open the file in Crystal Reports and go to File | Summary Info.

BIR Crystal Reports Summary
Once in the Summary Info, click in the keywords section and change the version listed to the same version of Sage 100 that is currently being used. Click OK and Save the report. 

BIR Crystal Reports Document PropertiesAfter the report is saved then the Wizard can be restarted and the templates will show like it should. Business Insights Reporter Wizard Template

Tags: Sage 100 ERP

Subscribe to Newsletter

Subscribe here for MBA Business Software's newsletter and product information to stay informed about the products and services offered by MBA.

90 Minds
90 Minds Consulting Group is an 
association of proactive consulting professionals who combine technology skills while still operating their own independent companies.

MBA Business Software
6100 Lake Forrest Drive, 
Suite 520
Sandy Springs, Georgia 30328
(P) 678-495-5700 
(F) 770-399-5772

Remote Office
Chicago, Illinois