time

[BlurredVision]

Does anyone know how to show a group by time, even if the time does not not exist in the database. Want to group a time field by 30 min intervals.

Thanks for anyhelp given...

 

[kenhamady]

Sounds like you have a time field, what do you mean by "if the time doesn't exist".

If you have a true time field you can group by hour automatically. To do 30 minute intervals you have to use a formula like:

if Minute ({@time}) > 30
then Time(Hour ({@time}), 30,00)
else Time(Hour ({@time}), 00,00)

You could group on this formula.
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[BlurredVision]

Kinda, But that's not it.. Sorry, I should have posted a example:

Example:

Group One - Date (01/20/2001)
Group Two - Hour (23:00)
Group Three - 30 min Intervals.

Reporting the following information
Date/Time Field
8/20/01 18:10:00
8/20/01 18:59:00
8/20/01 21:01:00

Since there isn't anything in-between 18:59 and 21:01, I would need
this the group (group 3) to report the heading only, instead it shows
nothing at all (which I know is normal)... how can I get around this?

Need the report group header three to show the following

18:00
18:30
19:00
19:30
20:00
20:30
etc...

 

[kenhamady]

The only solution is to have extra suppressed sections before each section.

You calculate the number of missing sections between one group and the next, and then unsuppress the appropriate number of these sections to fill the gap. You have formulas that display the times as if they were coming from the database. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/