BTerrell Group Blog

Drilling Down from Crystal Reports in Sage ERP Accpac 6

Posted by Meredith Gooch on Mon, Jun 14, 2010

Sage ERP Accpac 6 brings the ability to drill down from data in a Crystal Report. This ability is only available in the new Web version and not from the VB version. Report designers have the ability to add hyper-links to reports, which will trigger a user interface form to be run when the link is clicked on. The Crystal Report can pass data to the UI form to enable drill down. This is going to be a great feature. Thanks Stephen Smith for the information.

- Brian Terrell, CPA and Managing Partner

Tags: Crystal Reports, Accpac 6, Accpac Web version

Small Tip on Crystal Reports

Posted by Meredith Gooch on Thu, May 07, 2009

When designing a Crystal Report to be used in Sage Accpac ERP, most people are aware that if they have defined a parameter as “CMPNAME,” Accpac will pass the value of the login company name to the parameter. However, there is a another less-known parameter called “ACCPACUSERID” that will pass the user ID of the Accpac user who prints the report to the parameter. This parameter can also be used to restrict the viewing of certain data.

- Kristi Feng, Project Manager

Tags: Sage Accpac ERP, Crystal Reports