Help with Date Ranges and Arrays.

[LAD]

The following the record selection statementin my report.

{HPD:HelpDesk.Assigned To Group+} like "*DC*" and
({HPD:HelpDesk.Create Time}<{?Date} and {HPD:HelpDesk.Status} <> &quot;Closed&quot or
{HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and
({HPD:HelpDesk.Create Time}<{?Date} and {HPD:HelpDesk.Status-History.Closed.TIME} > {?Date})


I can run the report for a specific date but I need to get this information for a range of dates. If I change the parameter field to allow for mutiple values and choose the option Range Value(s) I get the error &quot;The array must be subscripted....&quot;

Any suggestions?

Thank in advance for any help or advice.

LaD

 

[mbarron]

I'm assuming you want dates outside of you range. To do this you need to add minimum's and maximum's to your formula so Crystal know you want dates outside of the range:


{HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and
({HPD:HelpDesk.Create Time}<minimum({?Date}) and {HPD:HelpDesk.Status} <> &quot;Closed&quot or
{HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and
({HPD:HelpDesk.Create Time}<minimum({?Date}) and {HPD:HelpDesk.Status-History.Closed.TIME} > maximum({?Date})

Mike
If you're not part of the solution, you're part of the precipitate.

 

[sk3]

I can run the crystal report with .net environment for a specific date but I need to get this information for a range of dates.Could you help me with that.

 

[LAD]

Actually the dates are not outside the range. I need to get this information for each day for every day of the month. I don't want to have to run a separate report for each separate day.

Thanks,

 

[mbarron]

The following will return the data for the dates in your range. As far as showing the info for each day seperately, you would probably need to set up a date grouping.



{HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and
({HPD:HelpDesk.Create Time}in{?Date} and {HPD:HelpDesk.Status} <> &quot;Closed&quot or
{HPD:HelpDesk.Assigned To Group+} like &quot;*DC*&quot; and
({HPD:HelpDesk.Create Time}in{?Date} and {HPD:HelpDesk.Status-History.Closed.TIME} in {?Date})


Mike
If you're not part of the solution, you're part of the precipitate.