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.
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
Comments
location 1 = 10
location 2 = 15
location 3 = 8
- sounds like you looking for a simple count :?:
OnPrereport()
NoOfEmployees := 0;
Onaftergetrecord()
NoOfEmployees := NoOfEmployees +1;
http://www.BiloBeauty.com
http://www.autismspeaks.org
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.
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/
http://www.BiloBeauty.com
http://www.autismspeaks.org