Find Jobs
Hire Freelancers

create a SQL report

£33-56 GBP

In Progress
Posted over 10 years ago

£33-56 GBP

Paid on delivery
I run a software called salon Iris. I want a custom SQL report to give me end of day totals. I have an old report written in MS Access which did this function but now it doesn't work as the database structure in V9 of salon Iris has changed. If possible I don't want to have to install MS Access just to run this report. Salon Iris allows custom sql reports in it's software, so maybe we now just need the report writing within salon iris in sql language. However I want it formatted for our ease, so be prepared to write a sql report that will run alongside the software and pull the information directly from the sql database. You can check the database structure as Salon Iris is available for free download here v9.33 [login to view URL] I have attached our old report that we used to use. I would like the same information on the new one. Basically it's and end of day report with all our relevant information on it. Our old programmer (10 years ago) used the existing software functionality to record the "cash starting balance" ( change in cash draw, which is not part of the takings) This new sql report needs to be able to select the date you want to balance. Add up all cash sales, all credit card sales etc. for that date Take account of payments made from the draw (this is recorded in Salon Iris software so the information is in the database) Take account of additional change put in the draw (this is recorded in Salon Iris software) List that days transactions. Then add the "starting balance" to the cash total (stating balance which was entered the previous day in Salon Iris) and now show the TOTAL amount of CASH IN DRAW so the cash draw can be counted and checked The report should be able to be printed on A4 I am familiar with Salon Iris so I can direct you to the functions it has.
Project ID: 4999774

About the project

19 proposals
Remote project
Active 10 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
19 freelancers are bidding on average £44 GBP for this job
User Avatar
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Regards, Hardik Shah
£50 GBP in 3 days
5.0 (17 reviews)
5.2
5.2
User Avatar
I have more than nine years experience in SQL reporting. Let me know the details of your report format. Thanks.
£54 GBP in 3 days
4.9 (34 reviews)
4.9
4.9
User Avatar
Hello, Can create this report for you. It can be excel file which will generate report you need. I didn't had time to check this software in details, but if it has some custom report editor, I can even implement this report on Iris side. Will give you final answer after will finish with user manual. Regards, Giorgi
£50 GBP in 3 days
5.0 (7 reviews)
4.2
4.2
User Avatar
Hi i have a good knowledge of SQL Reporting and i can provide you the same tell me when we can discuss the same
£62 GBP in 3 days
4.8 (7 reviews)
4.2
4.2
User Avatar
UK-based Access Developer with extensive knowledge of report design and SQL - I've been an Access developer for over 15 years. Although I've not used the system you mention before, I'm sure I can do what you need. I'm available on Skype to discuss further if required - cheers.
£63 GBP in 3 days
5.0 (4 reviews)
3.3
3.3
User Avatar
I have understand the requirement and I can create report from your database and can be send to your email address on desired time , Please contact me for the same. Thanks
£38 GBP in 2 days
5.0 (1 review)
2.8
2.8
User Avatar
I work with SQL and PL/SQL since 1992, including ETL and Data Warehouse and I have Oracle Certified Professional (Internet Application Developer Rel. 6/6i). I was instructor of Oracle Academy in Brasil, including those courses: Introduction to Oracle: SQL and PL/SQL, May/2000 Development PL/SQL Program Units, November/1999 Build Internet Applications I (Forms 6i), June/2000 Introduction to Oracle 9i - SQL. September/2001 Introduction to Oracle 9i - PL/SQL, September/2001 Build Internet Applications II (Forms 6i), February/2002 Tunning in SQL 9i (At9i), July/2002
£55 GBP in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
HI... I Can get it done For You ... As per your requirment.. Let me Know if i can be of any assistance to u .. Thanks .
£33 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear, I am SQL Expert and Microsoft Certified Master with over 10 years of experience in different areas of SQL. As an ex-Mckinsey Consultant I have consulted more than 300 clients related with SQL. Regards, Rahul
£44 GBP in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
hi I am experienced .net developer. I know MS sql server, MS access both. I dont understand what do you mean by report. I can give you query which will give to records / data as you wanted from database tables. thanks
£38 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , This is me yuvaraj who 4+ years of experience in SQL/PLSQL Programming , Here am new to this site but not for the technology , I hope we could do this project with the minimal time frame and also to produce the best outcome !!! Thanks ! yuvaraj.
£49 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working as dba in a finance company and my work involves only this ie of making scripts, i am new to free lancer so bidding very low not that i have less experience but new to freelancer.com
£33 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am very good in sql 2005 reports. you can trust me for that. i have 8 yrs of experience in share broking company as application programmer. i develope application in c# and sql server 2005.
£33 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A technocrat with 8+ Years (SQL Server2005/2008R2 +SSRS+SSIS) of extensive experience in Software Development Life Cycle (SDLC) & Project Coordination. Presently associated with ISTS InfoTech Solutions Pvt. Ltd. As Technical Lead. Skilful in administering projects using Web based Applications and ensuring its timely completion. Adept at all phases of SDLC, which includes Design, Analysis, Coding, Testing, Code Reviews, Implementation and System Support. Implementing the various life cycle stages of projects and demonstrated abilities in comprehending new technologies with ease. Demonstrated abilities in using various platforms such as SQL Server 2005/2008, SSRS, SSIS) Technology. A team player & effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.
£49 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I worked on a very large data warehouse where I had to create hundreds of automated reports based on different needs. I have worked with SQL and MSAccess for over 5 years and have thousands of report creations under my belt. Looking forward to creating a stunning report for you! Cheers!
£33 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm working for a company which provides customized ERP solution. I deal with a lot of SQL Queries and I'm very confident with this job.
£49 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Liverpool, United Kingdom
5.0
2
Member since Feb 3, 2007

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.