FYXGetFiscalQuarter Question

[jahgardener]

Under Crystal v9 Formula Function there is a section called Visual Basics UFLS. The formula I would love to utilize is:
FYXGetFiscalQuarter ({ALLOCEXP.ExpDate},7 ,1 )

(This provides the FY Qtr for an expense date when the fiscal year starts July (7) and the first day is the first (1))

I have used this in a report with some success, but it destablizes and crashes Crystal 9 after generating.
Has anyone else had a similar experience? Is there anything I need to be aware of when using this formula that I might be missing?

I need to set up parameters that allow the viewing of expenses for a particular quarter in a particular FY. The fiscal year begins July 1. In the past I have simply added 6 months to the date in question forcing the record into the correct FY but I would like to use this instead. Any
advice would be appreciated!

 

[dgillz]

When you say "it destablizes and crashes", what does that mean. Please post the EXACT error message you are getting.

Also, FYXGetFiscalQuarter() is not a standard crystal function, it is a UFL which most likely was included in crystal which came bundled with some other software. UFLs are made available to crystal by means of a .dll file that is registered on each workstation. Typically this file gets registered when the application is installed on the workstation.

Are you trying to run a Crystal report on a workstation which does not have the application which supplied the UFL installed? Is this a workstation dependent error?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[jahgardener]

The error message received is:

crw32.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

The report is being run from the machine in which the software has been installed. The FYXGetFiscalQuarter() formula is in a subreport,and the larger the output the more likely it is to quit and show the crw32.exe error message - with the program then shutting down.

I am going to experiment with the formula without the subreport layer and see how things go.

 

[dgillz]

I do not believe the error has anything to do with the subreport or with the UFL function.

To test this write your own formula to get the fiscal quarter:

If Month({YourDateField} in [1,2,3] then 1 else
If Month({YourDateField} in [4,5,6] then 2 else
If Month({YourDateField} in [7,8,9] then 3 else
If Month({YourDateField} in [10,11,12] then 4

When this happens is an error report generated? If so email this report to technical support at Crystal Decisions.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com