Using Crystal XI, I would like to group my data for each date in the date range. This is something I have never done nor have I worked much with crystal arrays, just trial and error.
I have defined a datetime date range parameter, Date Range, using any date range. This instance my date range is 6/1/10 to 6/15/10.
I do not know how the make my parameter a group.
I have also defined beginning date and ending date parameters.
I have tried creating an array for my date range from beginning date to ending date in an attempt to the Date Range Array formula a group but had not been able to figure it out.
Below is my Date Range Array formula where
@Number of Days is defined as datediff("d", ?BeginningDate, ?EndingDate) + 1
BeginningDate is 6/1/10
EndingDate is 6/15/10
Date Range Array is:
shared datetimevar array RangeDates;
redim DateTimeDates[{@Number of Days}];
numbervar end := {@Number of Days};
numbervar i;
for i := 1 to end do
(
RangeDates := ({?BeginningDate}+i-1);
);
Any direction would be appreciated.
Oscar115
I have defined a datetime date range parameter, Date Range, using any date range. This instance my date range is 6/1/10 to 6/15/10.
I do not know how the make my parameter a group.
I have also defined beginning date and ending date parameters.
I have tried creating an array for my date range from beginning date to ending date in an attempt to the Date Range Array formula a group but had not been able to figure it out.
Below is my Date Range Array formula where
@Number of Days is defined as datediff("d", ?BeginningDate, ?EndingDate) + 1
BeginningDate is 6/1/10
EndingDate is 6/15/10
Date Range Array is:
shared datetimevar array RangeDates;
redim DateTimeDates[{@Number of Days}];
numbervar end := {@Number of Days};
numbervar i;
for i := 1 to end do
(
RangeDates := ({?BeginningDate}+i-1);
);
Any direction would be appreciated.
Oscar115