0

It's my first time here and very new in SP. I have created a list for overtime of staffs. one overtime per list item. At the end of the month, the requirement is to print all overtime made by a staff (for that month) in one page. Maybe a Print button.

Can someone help me on how to accomplished this? Results should be Filtered by Name and Month.

Fields needed are:

Name | Date of OT | Description | OT Hours |

At the last row it should have the "Total OT Hrs" which will sum of all Over Time Hours.

Thank you in advance.

0

From previous experience, the majority of the time for any reporting and filtering I would export the list to Excel. Then add in custom calcs in Excel to generate the totals.

Alternatively, you could:

  • Create a page
  • Include the List webpart on the page
  • Customise the list view with the filters you have described.
  • Add custom code with either Content editor or script editor webparts to calculate your totals, place a 'Print' button on the page.

You did say you were new to SharePoint so the second option may require some learning. I would have included some links but some guides may differ based on the version of SP you are using.

  • Thank you for your inputs. Exporting to excel is what I was doing...however, its the "boss" who wanted it to be in SP, where he can just filter the staff name and Month (when the overtime was taken) to print the report. I already created a "Datasheet View" that has filter and totals...but i can't seems to find out how I can print it with a custom form. – Newbie Nov 19 '18 at 11:19
  • Ok, no problem. Have you tried using Javascript within a script editor webpart? Find or create a short script to print the page, and include it in script editor webpart. Which version of SharePoint are you using? – Geolog1cal Nov 19 '18 at 11:56
  • Nope have not tried JS within a script editor...however I tried putting a Print button on a content editor using the html editor "<code><input onclick="window.print();return" type="button" value="Print"/></code>" – Newbie Nov 19 '18 at 13:45
  • the above code only gives a snapshot of the form...we are using sharepoint 2010 – Newbie Nov 19 '18 at 13:55
  • Hello, sorry for the delay in reply - did you make any progress ? – Geolog1cal Nov 21 '18 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.