RS2005 SubTotal every 7 days

  • I have one particular payroll report that prints out daily payroll record of an employee for a selected date range (which could be for a month or years). Selection of employee and start/end date is through a parameter. Now I want to create a sub-total of hours worked and wages every 7 days starting from the start date.

    I tried creating another dataset with week numbers with corresponding start and endDate but I don't know how to "join" it with my payroll detailed dataset.

    Is there a better way of doing it? I'd really appreciate any suggestions or thoughts.

    jodjim

  • Try putting a subreport that uses the second dataset and pass in the parameters of the employee, and week numbers.

    Stuart

     

  • Appreciate your quick response. I haven't worked with sub-reports before but will give it a try. Thanks.

    hm

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply