Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Missing smq functions

Missing smq functions

Missing smq functions

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

RE: Missing smq functions

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
Accredited Crystal Decisions Enterprise Partner

RE: Missing smq functions


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 Lieberman

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close