Crystal Reports is a database-driven report system. Typically, all fields for reports must originate in the database. However, there are some fields that are not available in database fields that are useful for reports. These fields are handled by creating…
Articles
Graphs do not appear when printing Dashboard Reports
If you print a report containing a bar graph, and it shows you everything except for the graph, you are probably missing a needed DLL file. To resolve this issue, contact the Acctivate support team and refer to this article…
Posted in Reports
Acctivate crashes when printing sales order forms or invoices
This problem may be related to a large branch logo. Instead of loading the image one time, Crystal Reports loads the image for each line (record) on the sales order or invoice. The Crystal Reports temporary file is limited to…
Posted in Reports
Connect Crystal Reports to your Acctivate data
Acctivate uses standard Crystal Report files that link directly to the Microsoft SQL Server database server. This allows for report designers to work within Crystal Reports even when access to the Acctivate database is not available. However, it is very…
Adjust the number of decimals for a Quantity or Price field
Crystal Reports does not include an option to automatically adjust the number of decimals for a Number field. However, this can be accomplished with a simple formula for each field on the report. Right-click on the Field and choose Format…
Posted in Reports
Error “UFL ‘u2lgl’ that implements this function is missing” when logging in to Acctivate CYMA Version
After upgrading Acctivate components, specifically, the Crystal Report run-time component, CYMA IV users may receive an error when running a Crystal Report in the CYMA IV software. The error message is: UFL ‘u2lgl’ that implements this function is missing. CYMA…
Posted in Reports
“Update Crystal Reports XI R2 viewer” message repeatedly received
In some scenarios, users may receive the message “Updating Crystal Reports XI R2 viewer” and “Acctivate was not able to install all required updates. Please check the Acctivate log for details.” when running Acctivate on a Workstation. This is usually caused…
Posted in Installation, Reports
Acctivate Data View Definitions
The Acctivate relational database contains both tables and views. The database tables contain the raw data for lists, items and transactions. However, the tables require “links” to other tables to obtain user-friendly fields. For example, the customer table contains a…
Drill down from Crystal Reports and Dashboard
Acctivate offers drill-down capabilities from Crystal Reports® windows for reports and the dashboard to related Acctivate windows. Simply double-click on a data field that represents a window in Acctivate, such as Product ID, Customer, Order Number, etc. The above example shows…
Posted in Reports
Setup Printer Assignments for Reports
Acctivate allows users to assign specific reports to print from a certain printer by default. This can be helpful when printing product labels with barcodes, or to simplify the use of multiple printers in the same office. To access Acctivate’s report configuration…
Posted in Reports
