CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Failed User Login When Printing a Customized Crystal Report

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

by Sheila Zhang

We know that Sage 300 ERP is smart enough to use the local SQL database login to replace the SQL database login that is used on the development computer. So you don’t always need to install your client database when developing a general logic report for them on your computer. We did this for a while. However, you need to do this if you are referring to an additional data table or view created by yourself.

Unfortunately, last week, when I implemented a Crystal Report-related program on a client’s computer, I received an error about the SQL database login. The client is using Sage 300 ERP 6.0 and the user “accpac” was a valid SQL user and assigned in Sage 300 Database Setup configurations.  

However, the program and report worked perfectly on my testing server. So what happened? The interesting thing is I received another invoice form from the same person at the same time. When I ran the form, I got the same error.

Both reports have a special situation different from the original Sage 300 ERP reports. They all link an additional data table or view in the Sage 300 ERP database.

Then I tried to use the same environment as the client:

  • The same Crystal Report version
  • The same SQL database version
  • The same SQL native client driver
  • The same Sage 300 update
  • The same windows user group


Everything is the same but the report still got the error. The only difference is I didn’t have their company database and they don’t have the sample company database I used to develop the Crystal report.

And then I started to test the database:

  1. If I removed the custom data table from the report, the report printed successfully.
  2. If I created the same SQL login, user ID and password on my server, it didn’t help.
  3. If I created a dummy database with the custom data table.

After adding a dummy database and tables in the report with the same name as the client, the order confirmation printed without the issue.

 

My best guess is when Sage 300 printed the report, it first accesses the database stored in Crystal Report to validate the tables, views, and formulas instead of the database in Sage 300 Database Setup. After Crystal Reports validates the basics of the report, the Sage 300 ERP repost object replaces the login with the one assigned in Sage 300 Database Setup to grab the data. This replacement only happens to the Sage 300 ERP database tables. The additional data table or view still uses the original login in Crystal Report. 

Sage solved this issue in Sage 300 EP 2012. If you still work with Sage 6.0, to solve this issue, the best way is to install your client database, or at least create a dummy database with the same database name as your client.

Here is another way to fix the issue. You need to add a registry key on each computer:

1.       Go to[HKEY_LOCAL_MACHINE\(or \Wow6432Node\)SOFTWARE\ACCPAC International, Inc.\ACCPAC\repcmd] 

2.       Add a new key "alwayssetlocation" and set the value to "Yes"

It works, however it is risky.




Comments are closed.
On May 12, 2014 in General, Integration [Post:by]
Tagged With: Crystal Reports, Sage 300 ERP, Sage 300 ERP 6.0 / 10000 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 16200 Addison Rd. STE 270 / Addison, Texas 75001 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.