Home >> GoldMine
Add-ons >> CrysDLL Plus
If you develop or use Crystal Reports for GoldMine you
know how writing reports which read only the current
GoldMine record, contact group or which respect record
curtaining is almost impossible. Crystal simply does
not have the functions to do this.
- Provides GoldMine-specific user defined functions
for Crystal reports.
- Other functions convert ACCOUNTNO and RECID to
date/time allowing for easy reporting on record creation
dates
- Easy to install and use with example reports
- Allows you to write Crystal reports which select
the current contact record only or the currently active
group!
- Functions also read user permissions and group
membership, allowing record curtaining to be respected.
- Single licence covers your whole site and sub-site(s).
For a pdf version of these details click here.
CrysDLL provides a new set of functions which are
part of the Crystal function set – as shown in the
following screenshot.

All functions beginning with GM are from the CrysDLL
package.
These functions fill a much needed gap in the way
Crystal Reports can show GoldMine data. For example
the GMCurrentAccountNo function retrieves the GoldMine
account number of the currently displayed record and
can easily be used in record selection criteria to
show a report with other current record only. Similarly
GMActiveGroup gets the group number of the currently
active group in GoldMine, making it easy to write
reports which select only record in the current group.
Other functions convert Recids and AccountNo fields
to date/time, making it easy to report on records
in all GoldMine tables created within given time ranges.
Functions are also provided to support group membership
and curtaining.
CrysDLL Plus is a special format DLL which is automatically recognised by Crystal reports and adds user functions to the Crystal expression builder. The DLL implements functions which use a mixture of DDE and GoldMine API calls. Special logic ensures that the functions are efficient, only actually calling GoldMine when required. The functions can therefore be used in record selection criteria or similar situations without slowing them significantly.
Versions 5.5 onwards. However some functions will have problems with version 5.7.30503 due to a bug in the FrontRange code.
Our development has used Crystal 7, 8.5 as testbeds. It will probably work with Crystal 9 (although there are other known issues with this version of Crystal and GoldMine) and as we get confident in these versions we will confirm this. If in doubt please try it out with the evaluation.
CRYSDLL PLUS 1.2.1/2.2.1
We're delighted to announce a new release which now has two alternative DLLs - the old one which runs with GoldMine 5, 6 and 7 and uses the Borland Database Engine and the newer one which runs only on GoldMine 6.7 and 7 and which uses the new COM interface. The new one is strongly recommended if you are running newer versions of GoldMine as it has a simpler runtime and does not require BDE logins which can cause problems.
The core of the older version of CrysDLL is U2LGOL.DLL version 1.2.1 - the new one is U2LGOLC.DLL version 2.2.1.
Upgrade is free and simple. The new installer has both versions of CrysDLL and asks you which one you want to install. Your Crystal Reports will automatically select the new one which is backwards compatible in every significant way - the minor exception is the BDE functions which are no longer provided but are almost never used explicitly
Note that if upgrading to the 6.7 version you must remove manually all U2LGOL.DLL files.
To upgrade simply close GoldMine and Crystal Reports, then download the upgrade.
|