GoldMine DLL for Crystal Reports

[richardy]

This is a free DLL that allows you to access some encrypted values in GoldMine:

Download the free DLL from:

http://www.prior-analytics.com/forum/showthread.php?t=69

Place the Zip into the C:\Windows\Crystal Directory and unzip.

Functions available:

GMDateStringToSyncStamp(Datetime)
GMSyncStampToDateString(syncstamp)
GMCurrentAccountno - uses dde
GMCurrentUserName - uses dde
GMIsUserInGroup(User,Group)
GMUserGroupMembers(Group)



1. To get the date/time of a record from the RecID

DateTimeValue(GMSyncStampToDateString(Left({GoldMi ne_View.RECID}, 7)))

2. To bring back data for the active record (or user)

GMCurrentAccountNo = {CONTACT1.ACCOUNTNO}

GMCurrentUser = {CAL.USERID}

3. To test if a user is in a group

GMIsUserInGroup({CONTACT1.CREATEBY}, 'Group1')

or alternatively

InStr(GMUserGroupMembers('Agency'), {CONTACT1.CREATEBY} + ',') > 0

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.