Reports App from SQL Database - aaravsoft

IN PROGRESS
Bids
6
Avg Bid (USD)
$69
Project Budget (USD)
$30 - $100

Project Description:
The software I need is an app to generate reports from a SQL database. SQL database to be used on the development tests is attached.

The main table is the "dbo.Fichadas".
a) Inside this table we have a column called "Quien" ("Who" in English) with numbers only. We need to find this number on the "dbo.Personas" to get the "Nombre" and "Apellido" ("Name" and "Surname" in English) to be used on the report.
b) Inside this table we have a column called "Codigo" ("Event Code" in English) with the numbers "20", "21", "30" and "31". We need to replace "20" or "30" to "Entrance", and, "21" or 31 to "Exit" to be used on the report.

On the report I need the following columns names:
- "Name": "Nombre" (got from the "dbo.Personas")
- "Surname": "Apellido" (got from the "dbo.Personas")
- "Document Number": "Quien" (got from the "dbo.Personas")
- "Event": "Entrance" for the value "20", or "Exit" for the values "21" or "31"
- "Date": column "Capturada" (got from the "dbo.Personas"), splitted to get only the Date part
- "Hour": column "Capturada" (got from the "dbo.Personas"), splitted to get only the Hour part
- "Card Number": "Tarjeta" (got from the "dbo.Personas")

What I need on the app:
a) TAB 1
- Show all columns into a listView;
- Filter the rows by "Name" and a period "Date" (date must be entry using two DateTimePicker "From" "Until");
- IF filtered by name we'll see on the reports all events from this name;
- IF filtered by date we'll see access events during the selected period.
b) TAB 2
- View the results into reports (list, graph, pizza), using CrystalReports or similar;
- A print function;
- A PDF generator function;
- I'll need also the install file.
c) General
- The database will run into another PC so we have to point to the DB source;
- Another app use the same database;
- I'll need all source codes;
- Must be wrote using Visual C# 2010 or 2012 Express;
- I'm using the VisualStudio C# 2012 Express;
- The final appearance must be clean and well designed;
- This project is for my client, and with sure after done, some features or adds will be needed, so the freelancer must be availabe to be hired again for new projects I'll create for these upgrades.

Skills required:
C# Programming, SQL
Hire carelle
Project posted by:
carelle Brazil
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 88
in 5 days
$ 75
in 4 days
$ 100
in 3 days
$ 50
in 3 days
$ 72
in 6 days
$ 30
in 3 days