Search code examples
sqlfunctioncrystal-reportsformula

How do I determine what a Crystal Reports function does?

I have a custom crystal report which retrieves invoices from a database. There is a formula in the report that has the following code:

V6AttachmentsGetAttachment ({Command.AttachmentID},{?ReportAttachmentChannel} )

From my understanding, the formula has a function called 'V6AttachmentsGetAttachment' which takes two parameters (the first is a report field and the second is a report parameter).

This calculates a dynamic hyperlink.

How can I determine how exactly this is calculated? I am trying to figure out if I can replicate this calculation in SQL.

Is V6AttachmentsGetAttachment something that is stored in the SQL database? I can not find any references to it in Crystal Reports.

Solution

  • It could either be a custom function or one contained in a user-function library (UFL).

    Custom Function

    • Edit a formula (any formula will do)
    • Assuming that it is a custom function, it will be listed below the Report Custom Functions node:

    enter image description here

    UFL

    If this function is contained in a user-function library (UFL), you should see it listed in the Function tree:

    enter image description here

    u252000.dll contains a single function DateTimeto2000().

    If this is the case, then you will need to locate the source code for the UFL.