Hi all, hope this isn't too off topic...
My report accesses a database which holds infomation on http requests
from our intranet. Each record has a user, date, time and size of
transfer. I already have a working report which displays daily
summaries of the size transfered, and a link to a subreport for that
day.

In the subreport I linked the username and date parameters to the
record selection, and that works fine. I supressed the details
section, and placed my 00:00-00:15, 00:15-00:30... labels in the
header for the username group, so they don't all appear for every
record. I need a way to sum only those records which are in a
specified time bracket. I don't mind writting a function for each
bracket, but I don't know how to step through each record in the
function.

If there's another way, or anyone has any help, thanks in advance.
Hope I explained this ok,
Andrew Fray.

hmm, hope this helps a bit (fearing for it)
i would suggest trying w the details first, create an extra group and play w
that, if you got it working w the details showing, hide the details, don't
suppress them yust hide them.

you might want to try your luck on microsoft.public.vb.crystal 2


"Andrew" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all, hope this isn't too off topic...
> My report accesses a database which holds infomation on http requests
> from our intranet. Each record has a user, date, time and size of
> transfer. I already have a working report which displays daily
> summaries of the size transfered, and a link to a subreport for that
> day.
>
> In the subreport I linked the username and date parameters to the
> record selection, and that works fine. I supressed the details
> section, and placed my 00:00-00:15, 00:15-00:30... labels in the
> header for the username group, so they don't all appear for every
> record. I need a way to sum only those records which are in a
> specified time bracket. I don't mind writting a function for each
> bracket, but I don't know how to step through each record in the
> function.
>
> If there's another way, or anyone has any help, thanks in advance.
> Hope I explained this ok,
> Andrew Fray.

"EricJ" <ericRé(E-Mail Removed)> wrote in message news:<3fd5d183$0$27234$(E-Mail Removed)>...
> hmm, hope this helps a bit (fearing for it)
> i would suggest trying w the details first, create an extra group and play w
> that, if you got it working w the details showing, hide the details, don't
> suppress them yust hide them.
>
> you might want to try your luck on microsoft.public.vb.crystal 2
>
>
> "Andrew" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi all, hope this isn't too off topic...
> > My report accesses a database which holds infomation on http requests
> > from our intranet. Each record has a user, date, time and size of
> > transfer. I already have a working report which displays daily
> > summaries of the size transfered, and a link to a subreport for that
> > day.
> >
> > In the subreport I linked the username and date parameters to the
> > record selection, and that works fine. I supressed the details
> > section, and placed my 00:00-00:15, 00:15-00:30... labels in the
> > header for the username group, so they don't all appear for every
> > record. I need a way to sum only those records which are in a
> > specified time bracket. I don't mind writting a function for each
> > bracket, but I don't know how to step through each record in the
> > function.
> >
> > If there's another way, or anyone has any help, thanks in advance.
> > Hope I explained this ok,
> > Andrew Fray.

found an obvious answer that works - shared variables. Supress
details section, but add one function feild per time span required (eg
15 minute block). This function field initiates a shared var for that
chunk if onfirstrecord, otherwise adds the feild from that record to
that var. Then you need another function feild in a footer to display
that chunk's shared var. Long-winded, but effective.

Cheers anyway,
Andrew Fray