Pass database credential to sub report under the Custom report in Sage MAS 500

By | May 25, 2017

There was a very unique but interesting requirement from one of our clients recently; the issue is client had developed number of custom report with sub report on their test database system and their test database name was different with their production system so whenever they deploy all custom report with sub report, they got database name issue while printing a sub report because test database name was hardcode into the crystal reports.

New Stuff:- Migrate Purchase Payment from QuickBooks to sage 100

The requirement is client need to resolve the issue for existing custom report with sub report by passing database credential automatically to crystal report based on the existing user login.

Basically, in Sage MAS 500 there is no option is present for automatically passing database credential to sub report for custom report which is design at the client side.

To achieve this requirement, what we did we incorporated the changes into the standard exe “SMZRN001.exe” for passing database credential to sub report at run time.

By using this utility, user will be able to use the sub report option into the custom report which they can design the custom report into own Organization.

It would be interesting to know if this kind of functionality is required by others as well.

Also Read:

  1. Adding Filters and Security to Custom Reports in Sage 100 ERP
  2. Create Custom Reports in Sage 100 ERP using Business Insights
  3. Project Profit & Loss Report
  4. Monthly Rolling AR Report
  5. How To Create Custom Transaction Type In Mas 500 System

About Us

Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix have some unique solutions of Sage 300 integration with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services to Sage business partners, end users, and Sage PSG worldwide.