Rows to Columns for Report
- or -
Post a project like this2560
£30(approx. $37)
- Posted:
- Proposals: 2
- Remote
- #1497164
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
General information for the website: Sign in / Out log table to columns for a report
Database management system (DBMS): Microsoft SQL Server
Kind of development: New website from scratch
Description of requirements/features: I'm making a site in which will record when employees sign in and out, this logs to a table every time someone comes in and or out.
I need to take this data and put it into a report with in and out times in columns.
I have attached an excel file in which has a sample data set (quickly made up) and how this should be reflected in the report.
Should be simple, I just can't get my head around how to do this. I'd like it to be done in SQL directly however I'm happy if PHP / JS is required to do this better / correctly.
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Kind of development: New website from scratch
Description of requirements/features: I'm making a site in which will record when employees sign in and out, this logs to a table every time someone comes in and or out.
I need to take this data and put it into a report with in and out times in columns.
I have attached an excel file in which has a sample data set (quickly made up) and how this should be reflected in the report.
Should be simple, I just can't get my head around how to do this. I'd like it to be done in SQL directly however I'm happy if PHP / JS is required to do this better / correctly.
Extra notes:
Andrew P.
100% (5)Projects Completed
5
Freelancers worked with
4
Projects awarded
83%
Last project
10 Jun 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Dear Andrew, I think you need date wise in out report, if you clear it I can send you a demo link.
357771
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies