Crystal Reports 8.5 - Setting Time & Date

[Troopa]

Hi all,

We have some reports that came with an application and they have the option when you first run the report to specify a date range. This is right but we would also like to be able to specify a time range.

Do you know if/how this is possible?

Thanks

 

[Madawc]

Yes, DateTime can be an option on your parameters and elsewhere. Choose View > Field Explorer to get at the parameters.

Test that the parameters make will also need to be changed.

It helps to give your Crystal version; in this case it makes no difference but often it matters a lot.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

Oops - you did give your version, 8.5, sorry.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

If you want to specify certain times within a date range, you can create a time range parameter and then set up your record selection formula like this:

date({table.datetime}) in {?daterange} and
time({table.datetime}) in {?timerange}

-LB

 

[Troopa]

thanks guys, I'm having a few difficulties with it but I'll stick with it and if I can't worked it out I'll be back ;-)

 

[Troopa]

Sorry but not getting this much.
I have gone into Field Explorer and added two new fields under Parameters for StartTime & EndTime.

There is already two fields in there, StartDate & EndDate and these both have ticks nect to them and both show up when I run the report.

The question is now how do I get these (End&StartTimes) to show when I run the report?

Thanks in advance

 

[Troopa]

I've sorted it...