Group for each half hour

I am trying to make a report that lists phone calls that are grouped by time (using group export). I can do it by hour using the option "section will be printed: for each hour" but i need it to do it for each half hour and there is no option for that. It is possible do to it? How can i do it (In Crystal Reports 10 or 11)?

Thank you.Create a formula @.half_an_hour:

if minute({table.call_date_time})<30 or
(minute({table.call_date_time})=30 and second({table.call_date_time})=0)
then // returns h:00 - h:30
totext(hour({table.call_date_time}),0)&':00 - '&totext(hour({table.call_date_time}),0)&':30'
else // returns h:31 - h:59
totext(hour({table.call_date_time}),0)&':31 - '&totext(hour({table.call_date_time}),0)&':59'

The formula checks to see if the minute<30
or
is equal to 30 and the second=0 then it returns 'h:00 - h:30' otherwise
'h:31 - h:59'

Group your records on {table.cal_date_time} for each hour, suppress the GH and GF of that group;
then group your records on the {@.half_an_hour} formula.

As the 'Grop2 Name' field returns only time info, you will need to insert the {table.cal_date_time} and to format it as 'Date'.|||Thank you for the reply!! I can now group the calls by half hour.

Group By Week

Hi,
I have a matrix with month and week as the column grouping. Somehow
the week gets displayed twice when half of the week falls at the end
of the month and the other half in the beginning of the following
month. How do i set it so that the week only displays once?
TIA.
JMset the hide duplicates property on the cell property
mike
"Jordan" wrote:
> Hi,
> I have a matrix with month and week as the column grouping. Somehow
> the week gets displayed twice when half of the week falls at the end
> of the month and the other half in the beginning of the following
> month. How do i set it so that the week only displays once?
> TIA.
> JM
>|||Hi Mike,
I've tried that but the it only hides the header. In the end i still
have 2 columns displayed but one without the week number.
Thanks,
JM
"mike" <mike@.discussions.microsoft.com> wrote in message news:<1D104872-83DE-4D65-AD38-33A3EF0B8511@.microsoft.com>...
> set the hide duplicates property on the cell property
> mike
> "Jordan" wrote:
> > Hi,
> >
> > I have a matrix with month and week as the column grouping. Somehow
> > the week gets displayed twice when half of the week falls at the end
> > of the month and the other half in the beginning of the following
> > month. How do i set it so that the week only displays once?
> >
> > TIA.
> >
> > JM
> >|||Hi,
Here's my situation. After configuring the report to group by month
and by week, here's the output.
| January | Febuary
---
| WK 1 | WK 2 | WK 3 | WK 4 | WK 4 | WK 5 |
As illustrated here, there's a repeat of WK 4 because part of week 4
continues in febuary. Is there any way i can rectify this and only
display WK 4 under january or whichever month that has the most days
of that particular week?
Thanks.
Regards,
JM
jordanm@.37.com (Jordan) wrote in message news:<9ae5dece.0411181827.18b1289c@.posting.google.com>...
> Hi Mike,
> I've tried that but the it only hides the header. In the end i still
> have 2 columns displayed but one without the week number.
> Thanks,
> JM
>
> "mike" <mike@.discussions.microsoft.com> wrote in message news:<1D104872-83DE-4D65-AD38-33A3EF0B8511@.microsoft.com>...
> > set the hide duplicates property on the cell property
> >
> > mike
> >
> > "Jordan" wrote:
> >
> > > Hi,
> > >
> > > I have a matrix with month and week as the column grouping. Somehow
> > > the week gets displayed twice when half of the week falls at the end
> > > of the month and the other half in the beginning of the following
> > > month. How do i set it so that the week only displays once?
> > >
> > > TIA.
> > >
> > > JM
> > >|||The answer to issue is posted here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=9d321a2a-cc24-4999-be05-1bca5950dee1&mid=9d321a2a-cc24-4999-be05-1bca5950dee1
hth, cheers,
Cos
"Jordan" wrote:
> Hi,
> Here's my situation. After configuring the report to group by month
> and by week, here's the output.
> | January | Febuary
> ---
> | WK 1 | WK 2 | WK 3 | WK 4 | WK 4 | WK 5 |
> As illustrated here, there's a repeat of WK 4 because part of week 4
> continues in febuary. Is there any way i can rectify this and only
> display WK 4 under january or whichever month that has the most days
> of that particular week?
> Thanks.
> Regards,
> JM
> jordanm@.37.com (Jordan) wrote in message news:<9ae5dece.0411181827.18b1289c@.posting.google.com>...
> > Hi Mike,
> >
> > I've tried that but the it only hides the header. In the end i still
> > have 2 columns displayed but one without the week number.
> >
> > Thanks,
> > JM
> >
> >
> > "mike" <mike@.discussions.microsoft.com> wrote in message news:<1D104872-83DE-4D65-AD38-33A3EF0B8511@.microsoft.com>...
> > > set the hide duplicates property on the cell property
> > >
> > > mike
> > >
> > > "Jordan" wrote:
> > >
> > > > Hi,
> > > >
> > > > I have a matrix with month and week as the column grouping. Somehow
> > > > the week gets displayed twice when half of the week falls at the end
> > > > of the month and the other half in the beginning of the following
> > > > month. How do i set it so that the week only displays once?
> > > >
> > > > TIA.
> > > >
> > > > JM
> > > >
>