Find Jobs
Hire Freelancers

Generate reports using a MYSQL database

₱1200-10000 PHP

Closed
Posted about 6 years ago

₱1200-10000 PHP

Paid on delivery
Hi, 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.
Project ID: 16188886

About the project

16 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₱6,795 PHP for this job
User Avatar
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 also available on Skype for a more efficient communication. FYI, my last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that sends emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don’t hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius
₱10,000 PHP in 8 days
5.0 (28 reviews)
4.4
4.4
User Avatar
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 like, mysql, oracle, sql server, access, excel, etc. I have developed chart, cross tab, cube reports, sub-reports, on-demand reports using various versions of crystal reports. I can develop these reports and i can start immediately. Excellent communication skills and excellent reviews for the past projects.
₱8,888 PHP in 7 days
5.0 (11 reviews)
4.3
4.3
User Avatar
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 execution, and we’re dedicated to building the perfect website for your company on-time and on-budget. Scope of Services Research Design development Integration User Testing Support We Design Simple, Compelling, And functional Websites that make it easy for users to quickly find exact what they are looking for when they arrive to your site and then convert them into paying customers. Our team has rich experience in Website and Mobile App development. We provide the following Services: • Corporate Website/Portal • Website Re-Designing • Online store (E-commerce websites) • Informational websites • Social Network/Community building websites • Personal/Business Blogs • Mobile apps (iOS, Android & Hybrid) • Internet Marketing (SEO, SMO) Please note all our Websites & Mobile apps are developed as per our clients interest. we shall develop customized website as per your requirement. We sincerely believe that we are great fit for your Project & hence we are eagerly waiting for the opportunity. If you are looking for quality work, then please provide us an opportunity to explain you more about the work we will be doing for your website. I will be looking forward for your positive & fruitful response. Regards:- Saurabh
₱6,222 PHP in 20 days
5.0 (2 reviews)
2.9
2.9
User Avatar
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?
₱2,222 PHP in 7 days
4.8 (7 reviews)
3.2
3.2
User Avatar
A proposal has not yet been provided
₱3,333 PHP in 20 days
4.3 (7 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
₱5,555 PHP in 5 days
5.0 (2 reviews)
2.7
2.7
User Avatar
we have complete system with all your 9 models included in it ready to deliver now . see live demo chat with us
₱9,555 PHP in 3 days
5.0 (1 review)
0.8
0.8
User Avatar
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 you communicate is exactly what gets done, I'm your guy, I'm also very comfortable creating mobile applications and their related management applications and webservices that will serve data to them, A plus is my knowledge in third party application integrations and webservices and APIs which make use of data interchange formats such as XML, JSON, CSV, Serialized Data, etc, consider it done
₱6,222 PHP in 5 days
0.0 (0 reviews)
2.0
2.0
User Avatar
A proposal has not yet been provided
₱10,000 PHP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Tengo experiencia creando crystal report y uniendo a programas php y visual basic. Tambien he administrado un servidor de reporte.
₱7,777 PHP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PHILIPPINES
Philippines
0.0
0
Member since Jan 30, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.