Missing smq functions

[ryanatkinson]

A couple of years ago I wrote some reports
using CRW v6, and these reports made use of
a function called "smqtdif". It now appears
that the latest installations of CRW v6 and
v7 around the business do not have any of
the smq functions that I have on my PC.

I cannot remember whether or not these were
loaded on as optional extras, and if so
where I get them from.

Can anyone help?!

Ryan Atkinson
ryan.atkinson@bcm-ltd.co.uk

 

[dcm]

Ryan: These were almost certainly UDF functions i.e. created outside of CR, compiled into a DLL and copied into the Windows Crystal subdirectory where they are loaded as part of the startup of CR.

If you can't locate the original DLL file - probably called something like U2FSMQ.DLL then if you know how to do the calcuations invloved you could recreate them as UDF's using VB. If you need any more drop me a line David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner

 

[rosemaryl]

Ryan:

The SMQ functions you mention did not install with Crystal reports but with a product called SupportMagic, which is a helpdesk application. The SMQTDiff function was used to calculate the difference in seconds between two "string" date time fields, Example: SMQTDiff(ClosedTime,OpenTime)

The Magic product has evolved over time and is now at version 7 using Crystal Reports 8.0. They no longer supply the SMQ functions.

If you still have the original Magic CD you can copy the UFL (User Function Library) which depending on the version of magic was called CRUFLsmq.dll or UFLSMSQL.DLL. The dlls must be located in the WINNT\Crystal or Windows\Crystal directory for Crystal to recognize them. If it still doesn't show up under additional functions in Crystal then modify the path statement in the Autoexec.bat or in the Environment variables to include the mentioned directory.

If you have questions or need help regarding the use of the UFL please contact me. I provide Custom Report Writing on Magic and should be able to answer any questions you have.

Rosemary Lieberman,
Rosemary@microflo.com



Rosemary Lieberman
rosemary@microflo.com

http://www.microflo.com