Problem with a report

Imaspal
Imaspal Member Posts: 68
Hi Experts!

I have a report, where Wage Types and the time(hours) of every Wage Type are grouped by employees in a particular time. Particular time can be defined on a request form.

Now I have to add an analysis after every employee. In this analysis, there have to be the sums (time(hours)) of every Wage Type of an employee in the particular time given on the request form.

Can You Experts give me guidance with this?

Yours,
IP

Comments

  • DaveT
    DaveT Member Posts: 1,039
    Hi IP,

    On the face of it, this looks like a groupfooter section on the employee will work for you. If I'm reading your post correctly then you are already grouping by employee so using a GroupTotalFields or TotalFields will do the trick. If not write C/AL to calculate the figures in the OnPreSection on the groupfooter

    Hope this helps.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html