Summarize in Cross-Tabs per half hour

[kate8]

Hi,
I create a report using Cross-Tabs in Crystal Report XI. I need to do summarize for every half hour. The records are grouped by a field which data type is TIME (is in DB2). So in Cross-Tap Expert, under the group option, I only can choose "for each hour”,” for each second"...there is NO "for 30 minutes/half hour". Is there a way I can do "The column will be printed" for each 30 minutes/half hour?

Thanks a lot for any help!!

 

[lbass]

Create a formula like this:

if minute({table.time}) < 30 then
"00 - 29" else
"30 - 59"

Then use this formula in your crosstab.

-LB

 

[kate8]

lbass,

Thanks a lot!!!
I have created the formula, but couldn't test it since our database is down now. I believe it will work.

Have a nice weekend!