Create a Group From a Date Range Parameter 1

[southbean]

Hello All,

I don’t think this is possible (though it would REALLY make my life better if it is).

Is there a way to create a group from a date range parameter?

I need to create a group that displays each day starting on a {?StartDate} date parameter and ending on a {?EndDate}date parameter.

This is what I’ve got so far but it’s not working.

Whilereadingrecords;
Local DateVar myDate := {?StartDate};
//@datediff = {?EndDate} - {? StartDate }
Local NumberVar myDateDiff := {@datediff};
Local NumberVar i;
 
For i := 1 To myDateDiff Do
(
   myDate := CDate(DateAdd("d", i,{?start_date}))
);
myDate;

Many thanks to any/all replies!

- TL

 

[lbass]

You could group on the following formula:

Whilereadingrecords;
DateVar myDate := {?StartDate};
NumberVar myDateDiff := {?EndDate} - {?StartDate};
NumberVar i := i + 1;

if i <= myDateDiff then
(
myDate := CDate(DateAdd("d", i,{?startdate}))
);
myDate;

...as long as this is your only group. But then to get associated records you would need to insert a subreport, link the formula from the main report to the subreport (I don't think it will show a matching field), so then you would uncheck "select data in subreport based on this field, and then go into the sub record selection formula and add:

{table.date} = {?pm-@yourdateformula}

-LB

 

[southbean]

Hi LB,

OUTSTANDING! Exactly what I was looking for. That worked perfectly. The subreport tip was also very usefull as that is what I intended to do to get associated records.

Thanks again!

- TL