Time Formula

[Kinl]

I have a SQL database that holds time information and its broken down each half of an hour. I've been working on this for about 2 weeks now, trying to figure out how get a report that shows the data for each hour. I would have combine the data for that hour (which I have accomplished), but I cant get it to display a single hour. I can get it to show the hour that it happened it, but it still splits it apart into 2 fields in the details pane. Is there anyway i can say
'If count(timefield) >= 2 then
display timefield & timefielddata
else
0

Is there anyway to do this? thanks
donn

 

[kenhamady]

Post an example of what you are getting now and what you want it to look like. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Kinl]

Sorry, This might be a stupid question, but do you want a sample of the report, or a sample of the formula? Or both?

Thanx again.

 

[kenhamady]

Just a simple visual example of the output, current and desired. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)