crystal reports: summary fields

[Andrew]

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]

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" <an*********@hotmail.com> wrote in message
news:27**************************@posting.google.c om...

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.

[Andrew]

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote in message news:<3f***********************@reader0.news.skyne t.be>...

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" <an*********@hotmail.com> wrote in message
news:27**************************@posting.google.c om...

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