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)
13 freelancers are bidding on average £55 for this job
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