#3 Sage Accpac Reporting and Crystal Report

27 Mar

Date: 27/03/2011

Sage Accpac ERP uses crystal report and excel to do the reporting. By using Business object’s crystal report and Microsoft’s excel, Sage Accpac represent its data on report. Where Financial Reporter using excel to generate financial reports like balance sheet and profit and loss statement, wide tools of crystal report is used to render the ERP data for different modules in the reporting format.

In this article focus in manly on crystal report and its deployment in Accpac. Sage makes it very simple to customize existing report or to generate a new report form Accpac database and deliver it to the end users. With Accpac there are different ways that we can deliver the required report to the user. Either we can directly put the report designed report icon to the sage Accpac desktop or we can call the report through a VBA or VB program and put the short cut on the Accpac Desktop. When we are writing report in crystal for Accpac we need to keep few points in our mind.

Since Sage Accpac comes with the crystal report viewer we can directly put the report on the Accpac desktop and view it. When we run the report crystal parameter screen ask for the parameters user in the report if any. The important thing that we need to consider in that our report should work for all the companies and should pick the correct companies data from where it is running. For ex. if there are two companies set up in a client’s side one is ABC and other is XYZ, then Same report should pick the ABC company data when run from ABC company and XYZ data when run from XYZ company. Accpac provide mechanism for it. Sage Accpac pass “CMPNAME” Parameter that will have the name of the company from which the report been called and will also change the DSN of the report at the runtime to have the database for the company it is running from.

We can also record a macro or create a report UI to integrate our reports to Accpac Desktop. In either case, we must define our report in corresponding application’s report initialization file, xxrpt.ini. The report descriptor file is an ASCII file, structured in the

Windows “.INI” format. It includes the names and parameters of all the reports in our application. The command-level interface uses the report descriptor file. The report descriptor file is xxvvv\xxRPT.INI, where xx is the two-letter application id, and vvv is the program version. For example, the report descriptor file for General Ledger version 5.6A would be GL56A\GLRPT.INI. 

When we record a macro to display and print a Crystal report, the resultant macro code is only valid for displaying and printing the report locally, from the Sage Accpac ERP Desktop. To display the report from the Sage Accpac ERP Web Desktop, the macro code must be modified to use the AccpacPrintReport control, and the Crystal ActiveX Report Viewer must exist on the client.


1 Comment

Posted by on March 27, 2011 in Accpac & Crystal Report


Tags: ,

One response to “#3 Sage Accpac Reporting and Crystal Report

  1. Clash of Clans

    September 27, 2014 at 2:08 pm

    My brother suggested I would possibly like this web site.
    He was totally right. This publish truly made my day.
    You can not believe simply how much time I had spent for this information! Thank


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: