totaling/Count summary Fields

[Jimgarry]

Thanks in advance, Im new to Crystal

I am writing a report that has a summary field of employee dollars current earnings, then count the number of employees that have a check between 0 and $500, then 501 and 1000, etc.

I am not able to create a count on the groupu footer field taht totals each employee, is there any way around this.

Thanks

 

[synapsevampire]

Perhaps you can supply an example of what the report will look like?

You could create a group based on the amount by using something like:

If {table.amt} <= 500 then
&quot;500&quot;
else
If {table.amt} <= 1000 then
&quot;1000&quot;
else
If {table.amt} <= 1500 then
&quot;1500&quot;

etc.

Now group on this in a cross-tab or within a report itself.

Please post version of Crystal, database, example data and expected output for best results.

-k

 

[Jimgarry]

Hi thanks, that might work, I did look in the FAQ's agin and found something that is working.

I am creating a variable in the report header for the filed

numberVar acnt:=0

then in the group footer I am adding to this numbervar

whilePrintingRecords;
if {#CurrentEarningTotal} < 500 then
numbervar acnt:= acnt + 1

to display the total at the end of the report I am

WhilePrintingRecords ;
numberVar acnt


This seems to be working for what I need. thanks again for all the help

 

[Madawc]

Your method works, but Synapsevampire's method is better and a more efficient and flexible way to use Crystal.

Madawc Williams
East Anglia, Great Britain