Report giving totals.

kolaboy

Hi Folk,
I want to design a report that can total let say the number of employees in a particular institution.
Any Idea?
Thanks

Savatage

you mean you are going to run thru employee lines equaling a location or do you want all employees to list and subtotal them?

location 1 = 10
location 2 = 15
location 3 = 8

- sounds like you looking for a simple count :?:
OnPrereport()
NoOfEmployees := 0;
Onaftergetrecord()
NoOfEmployees := NoOfEmployees +1;

themave

This is not exact directions, but if you want to learn report writing try this

create a new key on the employee table

Global dimension one
No.

Then use the report wizard to create a new report based on the employee table, sort by the new key, group by global dimension one and create the report.

this will have all the basic info, a report with all in employee listed in a group for their department.

Now open the report, and create a variable to count the employee and it put this count in the group footer of the report. There are many reports that count records by group, open one of those and copy the idea from that.

Better yet, just use Harry's code above.

Savatage

Yes my directions were poor - but why global dimensions 1?

some companies do not use the dimensions and others might have dim1 set for some other code other than location.

that being said it still still get you moving in the right direction! \:D/

themave

Savatage wrote:

Yes my directions were poor - but why global dimensions 1?

some companies do not use the dimensions and others might have dim1 set for some other code other than location.

that being said it still still get you moving in the right direction! \:D/

Good point, coming from navision 2.0 were dimension 1 was hard coded as department code, which off coarse when we upgraded to 4.0 came over as global dim one. kind of forgot, there could be a lot of people that could have different use of dim 1