
SQL Server Reports Required
- or -
Post a project like this4595
£10/hr(approx. $13/hr)
- Posted:
- Proposals: 18
- Remote
- #360807
- Awarded
Microsoft Partner with Silver Competency; Microsoft Dynamics CRM & SharePoint
.NET Developer, sharepoint, ASP.NET, ASP.NET MVC, Entity Framework, Dev Express, Telerik
3226283595532761938490055261413523854132860457108719119239554648471071
Description
Experience Level: Entry
Estimated project duration: less than 1 week
I am looking to create several SQL reports (sales reports, staff sales / performance reports, total sales etc).
Some reports are simple, some are more complicated and I would be willing to provide you with a sample database and information on what reports I require.
A background to my project: I have a .Net winforms application that uses a MS Sql Server 2008 and/or 2012 database. Its designed for CRM / ticketing / POS software I have designed. I am a Windows C# developer of 15 years with very limited SQL coding skills which is why I am contacting you. I have created some basic reports but need someone like you with advanced skills.
The software uses Teleric Reporting (if you can design the reports using Teleric then this would be great!).
I can provide you with a sample database.
The reports I would like:
(Over different times i.e. Year, Monthly, Weekly, Daily)
[1] Employee Performance Report
Total Tickets Completed by each staff member for different time periods
Total Tickets Opened by each employee
Total Tickets Closed by each employee
Total Tickets Currently Open by each employee
Total Revenue for each ticket completed by each employee
[2] Sales Report
Total Sales
Most Popular Sale Items
[3] Products and Stock Report
Items In Stock
Items Out of Stock
Items Low Stock
Total Purchase Value of all Items in stock
Total Retail Value of all Items in stock
Items Purchase Price, Retail Price, % Markup
I will have more reports in the future but this is a good start.
If you need further information please let me know. I can provide you with sql scripts to create the database.
Some reports are simple, some are more complicated and I would be willing to provide you with a sample database and information on what reports I require.
A background to my project: I have a .Net winforms application that uses a MS Sql Server 2008 and/or 2012 database. Its designed for CRM / ticketing / POS software I have designed. I am a Windows C# developer of 15 years with very limited SQL coding skills which is why I am contacting you. I have created some basic reports but need someone like you with advanced skills.
The software uses Teleric Reporting (if you can design the reports using Teleric then this would be great!).
I can provide you with a sample database.
The reports I would like:
(Over different times i.e. Year, Monthly, Weekly, Daily)
[1] Employee Performance Report
Total Tickets Completed by each staff member for different time periods
Total Tickets Opened by each employee
Total Tickets Closed by each employee
Total Tickets Currently Open by each employee
Total Revenue for each ticket completed by each employee
[2] Sales Report
Total Sales
Most Popular Sale Items
[3] Products and Stock Report
Items In Stock
Items Out of Stock
Items Low Stock
Total Purchase Value of all Items in stock
Total Retail Value of all Items in stock
Items Purchase Price, Retail Price, % Markup
I will have more reports in the future but this is a good start.
If you need further information please let me know. I can provide you with sql scripts to create the database.
Paul B.
100% (1)Projects Completed
5
Freelancers worked with
5
Projects awarded
44%
Last project
29 Nov 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies