VB Crystal Report, How to use aggregates in reports?

microsoft.public.vb.crystal - Microsoft Visual Basic


VB Crystal Report >> How to use aggregates in reports?

by Jens Greven » Tue, 03 May 2005 23:51:36 GMT

Hi!

I'm currently evaluating CR11 and just try to build some report examples
with it. I'm currently stuck when it comes to using aggregates (like SUM)

Let's say there's a table like the following:

Object Issue Region Name Sales
1 200500005 1 MyExampleName 123456
1 200500005 2 MyExampleName 12345
2 200500005 1 Example2 234567
2 200500005 2 Example2 23456


Now i want the report to show
1 MyExampleName 135801
2 Example2 258023



So, no grouping or whatever, just the plain numbers are to be shown.
Can anyone please give me a hint how to achieve this?


Thanks in advance,
Jens

Top

VB Crystal Report >> How to use aggregates in reports?

by Briscobar » Wed, 04 May 2005 08:16:39 GMT






So, you want the SUM of Sales, per Name?


Running Totals could do it, I suppose. You'd have to have reset conditions
in the running totals, having it reset on change of Name.

However, if possible, creating a group based on Name looks to be the easiest
way. If not, then Running Totals are probably the way to go. But then again,
Running Totals aren't aggregate functions, per se. So it depends on what you
want to actually use as examples. If you want to show how to use the SUM
function, you'll need to use groups. If you just want to show how to get
totals without groups, then Running Totals are probbaly what you need.

HTH.

--
KB

MCNGP #26




Top
Similar Threads

1. Adding aggregated columns to a report - VB Crystal Report

2. Domain Aggregate Function equivalents in VB6 using ADO 

I don't know whether this is the right forum for this 
question. Maybe someone can guide to the right place. My 
question is this:

I am porting an access application to VB6 using ADO, but 
I'm being slowed waaaay down by the use in Access of 
DLookup, DCount, DSum, and all the macros behind the DoCmd 
command. Where can I go to get some help in translating 
these functions into VB6 and ADO.

I'm also using the Data Environment Designer to set up my 
VB6 forms and reports, but that isn't written in stone 
(yet!).

Any help would be greatly appreciated.

10-Q
Norm

3. Aggregate contacts of 20 users

4. Release date for information on aggregated levels (PS 2003) 

We are planning to implement Project Server, and as a part of that, I want
to make a dashboard for the unit managers to control ongoing projects in
their Business areas.
Although we want them to get a view of the projects, we do not want the
information to be available all the time - or at least, we want to "release"
the information after the Project manager has approved what's reported. This
is to save the PM for a lot of buzz when the top management gets their
reports.

Is this possible i PS 2003? Anyone tried it?

R

5. Aggregate Data Types???

6. Aggregate Function in Dataenvironment [multiposted]

7. Help: Aggregate Function in Dataenvironment

8. HELP!: Nested Aggregates 

Please help!

I have  a report with details of call records dumped from a phone switch. 
The details level shows the calls, agent who answered, if answered, wait 
time, talk time, etc.

Now, what i want to be able to do is count up the calls at one level (say, 
calls per day). Then at the next up level (say, week) i want to be able to 
see the average of the count of calls per day.
So i tried essentially: Average(Count({CALLID},@DayGroup),@WeekGroup)
But crystal refuses to let me do this. This is a very obvious and simple 
summary to do, and i dont understand why crystal chokes and dies on it.
Please, there HAS to be a way to do this. Ive tried Aggregates, like above, 
putting them in formulas, using running total fields, nothing works. It 
always complains that it hasnt a clue how to do this.

UGH!