SQL database report - repost

Closed

Description

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. I have the form with all the code and logic. If possible I don't want to have to install MS Access, or Crystal reports etc just to run this report. It would be preferable that this a stand alone app.

Be prepared to write a sql report that will run alongside the salon Iris 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 [url removed, login to view] [url removed, login to view]

I have attached our old report that we used to use. I would like the same information on the new one. I would like the report all on one page (a maximum of 2 pages on a very busy day which has more information) so any tables will need to be side by side.

Basically it's and end of day report with all our relevant information on it. It needs to be printed on A4 and keep track of how many times the report is run each day so I can check what the staff did to make the till balance at night.

Our old programmer (10 years ago) used the existing software functionality to record the "FLOAT for next day" (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 /receipts 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 "FLOAT for next day 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

This should be a stand alone app.

I am familiar with Salon Iris so I can direct you to the functions it has.

* I have the old ms access form with all the code.

* I have an example report which was printed (attached to this job)

Skills: Delphi, SQL

See more: www how to write a report, write report to me, sql programmer software, sql database programmer, report how to write, old programmer, ms access programmer, i need a ms access programmer, how we can write a report, how to write a written report, how to write a report for work, how to write a job report, how to be a programmer in 10 years, how i should write report, how is a report written, how can write report, how can write a report, how can one write a report, how can i write report, how can i write a report, delphi programmer job, crystal reports 10.0, cash account balance, a written report, what is ms sql

Project ID: #5340735

13 freelancers are bidding on average £55 for this job

itcslive

Dear sir, At first we like to say that we are a very experienced in programming languages ( php & mysql, ajax, JS, curl ) and expert in making custom cms with php script and can customize all major CMS like (joomla More

£84 GBP in 1 day
(6 Reviews)
5.4
feninsoftech

Hi, This can be achieved by designing a C# win-forms application, that will communicate with SQL Server database and generate report using SQL Server Reporting Services (SSRS). I have 9 years experience in develo More

£61 GBP in 5 days
(15 Reviews)
5.1
dbgeeks

Hello. My name is Dan Vail. I am a SQL expert. I am ready to author your report. I can make this a stand alone desktop application for you. Feel free to contact me with any questions you might have. Thanks for your con More

£83 GBP in 4 days
(6 Reviews)
4.6
LearningNew

I have queries............................................................................................................................

£45 GBP in 3 days
(4 Reviews)
4.6
elboukharimu

Hi, I'm very interested helping you creating your sql report, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there i More

£45 GBP in 3 days
(15 Reviews)
4.6
goswamiarpit475

Hi Sir, I am ready to work for you.I have 4 years of experience in C#. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please visit More

£50 GBP in 5 days
(3 Reviews)
2.5
amitchaps

Hi There, This is Amit. Expert in db & have worked with sql server db and reporting applications. I have provided a ball park estimate with GBP100. But i reccomend to have a discussion specifically for this p More

£100 GBP in 3 days
(1 Review)
0.0
dinoxw

i cannot find your example report attached if you choose me to help of course, i know that every business is unique and wish you my experience in delphi for years will give contribution to your business growth

£44 GBP in 3 days
(0 Reviews)
0.0
prabodhikatsl

Hi, I have more than five years of experience in developing crystal reports various domains, such as banking systems, rent a car systems, manufacturing organizations, etc. Therefore, I'm pretty much sure that I can More

£23 GBP in 3 days
(0 Reviews)
0.0
srinivasanrajan

Hi, I have 10 years of experience in crystal reports with various databases. like my sql, ms sql, etc. I have done many reports for various industries like Accounting, Inventory, Manufacturing, Job Costing Project M More

£44 GBP in 1 day
(0 Reviews)
0.0
kumar241915

Hi, I can create a report with the same business logic in Sql DB and SSRS and schedule the report to run at the specified time. If you are fine with that then provide me the details of the logic and structure of the More

£31 GBP in 1 day
(0 Reviews)
0.0
usherm

I've installed the Iris Software, had a look at the DB Schema.xml file that comes in the package installed so I could look at the database structure. The reason for the bid slightly above the budget was due to having More

£55 GBP in 1 day
(0 Reviews)
0.0
raiz0509

this is my first freelancing project. i want this project to showcase my skills, not for money.. check my credibility at in.linkedin.com/in/saurabhrai/

£55 GBP in 3 days
(0 Reviews)
0.0