In Progress

Reports App from SQL Database - aaravsoft

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 "[url removed, login to view]".

a) Inside this table we have a column called "Quien" ("Who" in English) with numbers only. We need to find this number on the "[url removed, login to view]" 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 "[url removed, login to view]")

- "Surname": "Apellido" (got from the "[url removed, login to view]")

- "Document Number": "Quien" (got from the "[url removed, login to view]")

- "Event": "Entrance" for the value "20", or "Exit" for the values "21" or "31"

- "Date": column "Capturada" (got from the "[url removed, login to view]"), splitted to get only the Date part

- "Hour": column "Capturada" (got from the "[url removed, login to view]"), splitted to get only the Hour part

- "Card Number": "Tarjeta" (got from the "[url removed, login to view]")

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: C# Programming, SQL

See more: what is database programming, view projects on freelancer, tests generator, sql pdf file, sql get date, sql database freelancer projects, sql code pdf, software development projects freelancer, reports freelancer, programming sql, programming graph, programming an app, number for freelancer app, my sql create database, m&b freelancer, list graph, graph programming, graph c sharp, get hired from freelancer, get freelancer app, freelancer view projects, freelancer tarjeta, freelancer sql database, freelancer sql c#, freelancer software programming

About the Employer:
( 56 reviews ) Valinhos, Brazil

Project ID: #5021171

Awarded to:

aaravsoft

Hello, I have an 12 years of experience in .net technology with C#.Net, VB.Net, Asp.Net, Kendo UI, Asp.Net MVC with Sql Server, MySql, Oracle and Access. I have also same experience in HTML5, Css, Jquery and Ja More

$75 USD in 4 days
(18 Reviews)
3.9

6 freelancers are bidding on average $69 for this job

customizedata

I have gone through all the details. Sql database stuff is also very clear. "Quien" column will be the relationship between two tables. We will use crystal reports,but one thing i want to clarify you is 1- Express More

$88 USD in 5 days
(65 Reviews)
5.7
mahesagrimba

Hi, I have done similar project that generating report from sql server. Please kindly see portfolio for detail project Regards

$100 USD in 3 days
(1 Review)
1.6
gdragomir

Hello, Thank you for inviting me. I can complete this in 3 days. I will use ReportViewer integrated with a C# desktop application. Thanks, George

$50 USD in 3 days
(1 Review)
0.0
RayyanTahir

Dear Sir, I am impressed with the way you properly described how your application needs to be done. I always feel comfortable with employers who have clear requirements for their applications. I am good at More

$30 USD in 3 days
(0 Reviews)
0.0
heb

I have a vast and excellent experience in using .NET environment and SQL server database to create application similar to your project.I have developed a fast food auto system(which works like a point of sale software) More

$72 USD in 6 days
(0 Reviews)
0.0