Generate reports using a MYSQL database


We are looking to build external (MYSQL based) reports for our (input) program – Inflow Inventory. We currently have Crystal reports but will consider other programs like Excel...for ease of use sake.

9 main general reports with sub reports (switchable by total company/brand & time period). If we will not use excel, the data should be able to be exported to excel & ppt as a table or chart form.

These are the reports we want:

1. Monthly sales (chart)

2. Moving annual total | 12 month sales data (chart)

3. Quarterly sales vs YAGO (chart)

4. Monthly sales analysis vs YAGO (chart)

5. Distribution of business (chart & table. absolute & Percentage)

6. SKU distribution (peso value & units) (month &/or year) (per branch & total company)

7. Average sales per branch | HQ | total company

8. Sales by Kiosk

9. Inventory by location (current)

Attached here are sample pictures & instructions on how we calculate the data.

It would be great if you could demo for me your proposed solution. Please indicate how long it would take to complete this project

Thank you for your time.

Skills: Database Programming, Excel, MySQL, PHP, SQL

See more: create reports php using mysql database, monthly reports using mysql database, create reports php using mysql database mysql php, mysql workbench reporting tool, how to generate report from mysql database in php, mysql report generator open source, how to generate pdf reports in php with mysql, dmyreports, how to generate report in php example, mysql crystal reports, mysql report maker, php, mysql, css, html, jquery / prototype, using mysql database generate pages wordpress, quickbooks using mysql database, using mysql database netbeans j2me, cnet mobile application using mysql database source

About the Employer:
( 0 reviews ) Philippines

Project ID: #16188886

17 freelancers are bidding on average ₱6918 for this job


Hi Mr. Employer we can connect your MySql using the MS Access and get your required reports too. I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your req More

₱1200 PHP in 1 day
(49 Reviews)

Hello. After reviewing your post, I am very interested in that due to my experience. I’d like to be considered for your project position. I am an web db expert . I will satisfy you with high quality and lower pric More

₱8888 PHP in 3 days
(19 Reviews)

Hello, i read your project description about crystal reports developer. I have over 7 years of experience as a reports and database developer. I have developed well over 2500 reports so far using various data sources More

₱8888 PHP in 7 days
(9 Reviews)

Hello, I could create an Excel VBA tool that connects to the MySql database in order to download the necessary data for the report with a single button click. Then the reports will be automatically updated. I'm a More

₱10000 PHP in 8 days
(26 Reviews)

A proposal has not yet been provided

₱3333 PHP in 20 days
(7 Reviews)
₱10000 PHP in 20 days
(2 Reviews)

Hello sir, I just go through whole project description and find us able to fulfill required improvements. we hold one goal above all others: 100% client satisfaction. highest standards for project planning and execu More

₱6222 PHP in 20 days
(2 Reviews)

So you need your inventory report in excel form for easy use. Do you have any format? do you use this excel sheet for other application for data exchange? do you also need to show chart on the excel report?

₱2222 PHP in 7 days
(7 Reviews)

A proposal has not yet been provided

₱5555 PHP in 5 days
(1 Review)
₱7777 PHP in 3 days
(1 Review)

Hello sir , I am expert with php , mysql . I can create report for you and even whcih can be exported using excel format . Please review and let us know your feedback. Regards, [login to view URL]

₱7530 PHP in 5 days
(3 Reviews)

I have years of experience in HTML, Javascript, PHP, NodeJS amongst other web and desktop application technologies, I also have excellent English Grammar and Comprehension abilities, this helps in ensuring that what yo More

₱6222 PHP in 5 days
(0 Reviews)

we have complete system with all your 9 models included in it ready to deliver now . see live demo chat with us

₱9555 PHP in 3 days
(0 Reviews)
₱6222 PHP in 3 days
(0 Reviews)
₱6222 PHP in 3 days
(0 Reviews)

Tengo experiencia creando crystal report y uniendo a programas php y visual basic. Tambien he administrado un servidor de reporte.

₱7777 PHP in 7 days
(0 Reviews)

A proposal has not yet been provided

₱10000 PHP in 2 days
(0 Reviews)