Report giving totals.

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

Comments

  • SavatageSavatage Member Posts: 7,142
    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;
  • themavethemave Member Posts: 1,058
    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.
  • SavatageSavatage Member Posts: 7,142
    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/
  • themavethemave Member Posts: 1,058
    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
Sign In or Register to comment.