{"id":1406,"date":"2017-05-25T15:26:13","date_gmt":"2017-05-25T15:26:13","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1406"},"modified":"2025-06-12T04:39:39","modified_gmt":"2025-06-12T04:39:39","slug":"pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/","title":{"rendered":"Pass database credential to sub report under the Custom report in Sage MAS 500"},"content":{"rendered":"

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 subreport on their test database system and their test database name was different with their production system so whenever they deploy all custom report with subreport, they got database name issue while printing a subreport because test database name was hardcode into the crystal reports.<\/p>\n

New Stuff<\/strong><\/em>:\u00a0Migrate Purchase Payment from QuickBooks to sage 100<\/a><\/p>\n

The requirement is client need to resolve the issue for existing custom report with subreport bypassing database credential automatically to crystal report based on the existing user login.<\/p>\n

Basically, in Sage MAS 500 there is no option is present for automatically passing database credential to subreport for a custom report which is design at the client side.<\/p>\n

To achieve this requirement, what we did we incorporated the changes into the standard exe \u201cSMZRN001.exe<\/strong>\u201d for passing database credential to subreport at runtime.<\/p>\n

By using this utility, a user will be able to use the subreport option into the custom report which they can design the custom report into own Organization.<\/p>\n

It would be interesting to know if this kind of functionality is required by others as well.<\/p>\n

About Us<\/strong><\/span>
\nGreytrix is a 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.<\/p>\n

Greytrix<\/a>\u00a0has some unique solutions of\u00a0Sage 100 integration with Sage CRM<\/a>,\u00a0and Salesforce.com\u00a0<\/a> along with Sage 100 Migration from Sage 50 US, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n

For more details on Sage 100 Services, please contact us at\u00a0sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

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 subreport on their test database system and their test database name was different with their production system so whenever they deploy all custom report with subreport, they got database name\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[116],"tags":[267,280,431,467],"class_list":["post-1406","post","type-post","status-publish","format-standard","hentry","category-mas-500","tag-custom-report","tag-database-credential","tag-sage-mas-500","tag-sub-report"],"yoast_head":"\nPass DB Credentials to Sub-Reports in Sage MAS 500<\/title>\n<meta name=\"description\" content=\"Step-by-step instructions to pass database credentials to sub-reports in custom Sage MAS 500 reports, ensuring seamless data access and report generation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pass DB Credentials to Sub-Reports in Sage MAS 500\" \/>\n<meta property=\"og:description\" content=\"Step-by-step instructions to pass database credentials to sub-reports in custom Sage MAS 500 reports, ensuring seamless data access and report generation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-25T15:26:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-12T04:39:39+00:00\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/\",\"name\":\"Pass DB Credentials to Sub-Reports in Sage MAS 500\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"datePublished\":\"2017-05-25T15:26:13+00:00\",\"dateModified\":\"2025-06-12T04:39:39+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Step-by-step instructions to pass database credentials to sub-reports in custom Sage MAS 500 reports, ensuring seamless data access and report generation.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pass database credential to sub report under the Custom report in Sage MAS 500\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pass DB Credentials to Sub-Reports in Sage MAS 500","description":"Step-by-step instructions to pass database credentials to sub-reports in custom Sage MAS 500 reports, ensuring seamless data access and report generation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/","og_locale":"en_US","og_type":"article","og_title":"Pass DB Credentials to Sub-Reports in Sage MAS 500","og_description":"Step-by-step instructions to pass database credentials to sub-reports in custom Sage MAS 500 reports, ensuring seamless data access and report generation.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2017-05-25T15:26:13+00:00","article_modified_time":"2025-06-12T04:39:39+00:00","author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/","name":"Pass DB Credentials to Sub-Reports in Sage MAS 500","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"datePublished":"2017-05-25T15:26:13+00:00","dateModified":"2025-06-12T04:39:39+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Step-by-step instructions to pass database credentials to sub-reports in custom Sage MAS 500 reports, ensuring seamless data access and report generation.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/05\/25\/pass-database-credential-to-sub-report-under-the-custom-report-in-sage-mas-500\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Pass database credential to sub report under the Custom report in Sage MAS 500"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=1406"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1406\/revisions"}],"predecessor-version":[{"id":3052,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1406\/revisions\/3052"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}