Em Andamento

Employee Flash Card Report - part 2

The first stage of the project involved creating an employee flash card report. The report tracks the performance of an employee working for a metal parts manufacturing company. The two items tracked are:

1) TAKT Time Average - how fast the employee performed their assigned operations

2) Quality Average - how many rejected parts versus good parts were made

The report includes rolling averages for the past 12 months for both the employee in question and the rest of the company for comparison purposes. A PDF with such a report is attached. The existing report is built using

This project involves a second stage, where the reporting data needs to be filtered and aggregated.

Data aggregation is to be done by:

(a) name(s) (drop down multiselect)

(b) department(s) (drop down multiselect)

(c) shift(s) (drop down multiselect)

(b) departments

Data filtering needs to be done by:

(a) part number (text search allowing wildcards)

(b) work order number (text search allowing wildcards)

(c) operation number (text search allowing wildcards)

The current database contains the list of employees, but without specific relationships between them - which shift, which department. A table indicating the relationship will have to be created in the database, with a corresponding IIS web form to allow the user to quickly "build" the relationships (see attached diagram in excel).

Technical notes: SQL 2012 Standard server, report built in Visual Studio 2010 shell using reporting services, and currently housed by SSRS.

Habilidades: .NET, IIS, Elaboração de relatórios, Arquitetura de software, SQL

Veja mais: card flash, card flash con asp, pdf flash software, xml flash card flash, search form flash, flash relationship, happy birthday card flash, flash order form, christmas card flash fla, visual card, scratch card flash, flash search form, holiday email card flash, part time flash project, visual studio excel project, sql server reporting services work, scan report card recreate, fla christmas card flash, coca cola christmas card flash, creating order form flash

Acerca do Empregador:
( 11 comentários ) Knoxville, United States

ID do Projeto: #5124905