crystal reports: summary fields

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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.
 
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
 
EricJ said:
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
Click to expand...

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
 
Back
Top