How exactly are you using the FiscalPeriod (date) function?

Does the error only occur when you open the report, or does it actually happen during printing (or preveiwing)? Please tell us what the error is.

If your 'Fiscal Year' does not match the actual Calendar Year, then you may have to create a formula to get the correct fiscal information.

For example, if you want columns on your report for specific fiscal periods, you could custom design some formulas to accomodate this. For example, if your Fiscal Calendar is June 1 through May 31, your formulas would look something like this:

For your fiscal period 12 (May, 2002):
if Month(date) in 5 to 5 and Year(date)= 2002 then amount

You can then format the formula field to 'suppress if 0' to clean up the report.

Alternatively, if you have inserted the 'Fiscal period' field onto your report, the formula for the above FP could be:
if {ALW65 Posted Transactions.Fiscal period} = 12 then {ALW65 Posted Transactions.Home amount}

Hope this helps!

You are using the function correctly then, yes - it works as explained in the documentation.

How are you previewing the report after you have closed Crystal Reports for Adagio 'totally'? This is not possible using just Crystal for Adagio.

The capability to compile reports is not an option in Crystal 8.5 for Adagio. The CR4A manual explains this in Appendix B, p.B-4.

Regards

You indicated that the error only occurs when you are trying to preview or print the report from an icon or another system.

As indicated previously, compiled reports and Report Distribution Expert are no longer supported in Crystal 8.5. This means that all users must run the Designer to print reports. Given the license model, this means one copy of Crystal Reports for Adagio must be purchased for each workstation that wants to print reports.

We cannot provide technical support if you are using Crystal Reports for Adagio with compiled reports in this way. If you have no problem when running the report while in Crystal Reports for Adagio, then we do not have an issue.

It is still possible to export reports to other formats such as Excel for viewing by users who do not have a copy of Crystal installed.

Take care,

When I tested this here - I did not find a problem, however - I did not try creating a shortcut icon for the report, and try running it from the shortcut. I incorrectly thought that you had compiled the report and put it on your desktop - I apologize for the misunderstanding!

Since the shortcut itself will open Crystal and go directly to the preview, I can't see how this would affect the report initially, unless it has something to do with the 'save data with report' option. By default, this option is enabled. You can go into File - Options and turn this off if you like, as you can set it individually on reports as needed.

Can you try turning off this option, then save the report? Does it work then? This would mean that you would get fresh data each time, unless there is another reason you do not want to refresh the data.

I will post the results of my further testing as soon as I can - thank you for your patience, Ian!

Martin - thanks for your input. To make things clearer (I think! ), Crystal Reports 8.5 for Adagio is a fully functional Standard Edition of Crystal 8.5, modified as per license to work specifically for Adagio and related datasets.

Yes, you can download a utility from the Crystal Decisions web site that adds report distribution and compilation functions into Crystal Reports. Using Compiled Reports and the Report Distribution Expert with version 8.5 of Crystal Reports is ONLY supported when used with the Developer Edition.

Using Compiled Reports and the Report Distribution Expert with Crystal Reports for Adagio is a violation of the Crystal Reports license agreement and is not supported. A dealer who has purchased a copy of Crystal Report for Adagio could also purchase a copy of the Crystal Reports Developer Edition. The dealer could then design compiled reports for clients and deploy them at the user site. The user would be required to have at least 1 copy of Crystal Reports for Adagio installed. However, at this time we have not certified this will work, and we will not be providing technical support for this environment.

Thank you for your attention to detail in your last post - this will help greatly!

Please give us some time to try to reproduce this here, and we will get back to you with our findings.

Take care,

Further testing using the steps you have provided, showed the same results that you have found. In other words, there is a problem.

I will have to consult with R&D on this, and get back to you. I will do this asap.

Thank you for reporting this, and also thank you for your persistence and patience with your responses.

Sincerely,

Further testing indicates that for some reason, when you first create the report and run it - the FiscalPeriod(date) works (i.e. is loaded by Crystal) - however, after exiting Crystal Reports for Adagio then coming back in and trying to print the report, it fails (i.e. the function is not being re-loaded). BTW, this problem exists for the other Fiscal functions that are specific to Adagio/ACCPAC Plus reporting from Crystal Reports 8.5 for Adagio - it is not just the FiscalPeriod(date) function.

When it works, you should be able to see the function listed under the heading 'Additional Functions' in Crystal Reports for Adagio. Notice that when it gives you errors, the function does not appear in this list any longer...the big question is why?!

For now, R&D is looking into it. I do not know when they will have a resolution - however, there are other ways to get the information you want. Please refer to the original post that we replied to you with - some examples were listed that you can use to work around this problem for now.

(i.e. For example, if you want columns on your report for specific fiscal periods, you could custom design some formulas to accomodate this. For example, if your Fiscal Calendar is June 1 through May 31, your formulas would look something like this:

For your fiscal period 12 (May, 2002):
if Month(date) in 5 to 5 and Year(date)= 2002 then amount

You can then format the formula field to 'suppress if 0' to clean up the report.)

Once again, thank you for reporting this.

As this is a new feature in Crystal Reports for Adagio, it cannot affect any previously designed reports. If your fiscal calender is on monthly boundaries, I would be happy to provide a formula to you that would not need adjusting every year.

Regards

Could you tell me whether your fiscal calender = normal calender (Jan = 1, Feb=2 etc) or whether the fiscal year starts on another month?

Also, why are you using the fiscal calender for a debtor's aging? Why not just subtract the due date from TODAY()?

You aren't required to use one of the pre-defined Date Ranges when creating formulas. They're easier to use, but not necessary.

Instead of the 'FiscalPeriod' function, you can use the 'Month' function to do a similar thing.
ie IF Month(PrintDate)-Month(Date)=n THEN...
or IF Month(Today)-Month(Date)=n THEN...
(where n is the number of months ago)

The only difference is when the dates are in different years. You have to use the 'Year' function as well as 'Month' to calculate n.
ie IF Month(PrintDate)-Month(Date)=n AND Year(PrintDate)=Year(Date) THEN.... etc

If your ranges are meant to be based on days, rather than months, you can create formula columns such as...
IF PrintDate-Date in [31 to 60] THEN...
IF PrintDate-Date in [61 to 90] THEN...

When you subtract one date field from another, the result is the number of days difference between the two dates.

Regards,