Solved

How to make an array of dates in Crystal

Posted on 2011-03-15
7
1,618 Views
Last Modified: 2012-05-11
I need to check for holidays in my report.  I put this formula in the report header.

I have tried to make an array of dates in Crystal as follows:

BeforeReadingRecords;
Local DateVar Array Holidays:= MakeArray(Date(2011,01,01),Date(2011,12,25))

I get an error message that says "Result of formula cannot be an array"

How do I format the formula to create the array?
0
Comment
Question by:DSIGRIS
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 35140750
Try it this way

BeforeReadingRecords;
Local DateVar Array Holidays:= [Date(2011,01,01),Date(2011,12,25)];
""

Crystal returns the value evaluated in the last line as the result of the formula.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35140766
Not sure what you are doing but here is a formula that does the Number of WorkdDays between 2 dates and account for holidays

http://www.kenhamady.com/form01.shtml

mlmcc
0
 

Author Comment

by:DSIGRIS
ID: 35141155
I was trying to implement your solution for calculating the difference between two dates.

//Holiday Listing formula to go into the report header of the report.
BeforeReadingRecords;
DateVar Array Holidays := [Date (2003,12,25), Date (2003,12,31)];

But this gives me an error.

0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 100

Expert Comment

by:mlmcc
ID: 35141517
You need a final line that is a scalar value like ""

//Holiday Listing formula to go into the report header of the report.
BeforeReadingRecords;
DateVar Array Holidays := [Date (2003,12,25), Date (2003,12,31)];
" "

mlmcc
0
 

Author Comment

by:DSIGRIS
ID: 35141585
Why is that?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35143513
Crystal returns the value from the last statement it executes or evaluates as the value of the formula.  In your case the declaration of the array so it tries to return the array as the value which is not allowed.

If you had used
//Holiday Listing formula to go into the report header of the report.
BeforeReadingRecords;
DateVar Array Holidays := [Date (2003,12,25), Date (2003,12,31)];
numberVar HolidayCount := 2;

That would be fine because it would return 2 as the value.

Formulas on the report need to display something.

mlmcc
0
 

Author Closing Comment

by:DSIGRIS
ID: 35149072
Great Job thanks.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question