Solved

Need software for retail door counter, maybe crystal reports.

Posted on 2008-10-01
14
543 Views
Last Modified: 2013-11-15
Hello,

   I have a customer with a simple one entrance door counter, that sends the data to a wireless reciever which is connected to the server in the store.  They use "Edge" as there POS software.  I'm looking for a way to take the number of sales, and amount of sales from edge, and compare it to the number of people that came through the door, and come up with a closing ratio for there sales reps.  Edge will export data, and the door counter exports the count data.  Now I need something to make the calculations and report it.  The door counter manufacturer recommends crystal reports.  I'm open to any comments or suggestions.  The key thing here is automation, the customer wants to do as little as possible to come up with the closing ratio.  
0
Comment
Question by:seanrhudy
  • 8
  • 5
14 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
What data do you have?

Is it in a database?

It seems from what you say you want a CLOSURE RATE that Crystal is a bit of an overkill.  

What do you have available for developing a program?

mlmcc
0
 

Author Comment

by:seanrhudy
Comment Utility
I'm waiting for a call back on what the data will export as from Edge.  I have pretty much anything for developing.  I'll post as soon as I find out the rest of the info.
0
 

Author Comment

by:seanrhudy
Comment Utility
All exports in the Edge POS software are in csv format.
0
 
LVL 4

Expert Comment

by:BostonMA
Comment Utility
How about just a stored procedure on a server which you schedule and have it email whoever you need to notify....
0
 

Author Comment

by:seanrhudy
Comment Utility
I can either export the couter data in xml format or pull it from the sql database, and like I noted before, the Edge POS software exports to CSV format.  Would a stored procedure still be the best way to go?  Would it be easy to do other similiar reports with it? Like closing ratio for the day, month, quarter?  Also, the report needs to be somewhat clean looking, as multiple people will be analyzing the data.  What do you think?
0
 
LVL 4

Expert Comment

by:BostonMA
Comment Utility
Sorry I thought you were only looking for raw calculated values.  The stored procedure wont give you a clean report. I'm just curious how you are planning on delivering this report to them? Do you have crystal reports server?
0
 

Author Comment

by:seanrhudy
Comment Utility
I can either export the couter data in xml format or pull it from the sql database, and like I noted before, the Edge POS software exports to CSV format.  Would a stored procedure still be the best way to go?  Would it be easy to do other similiar reports with it? Like closing ratio for the day, month, quarter?  Also, the report needs to be somewhat clean looking, as multiple people will be analyzing the data.  What do you think?
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 

Author Comment

by:seanrhudy
Comment Utility
I have crystal reports developer, do I need anything else? Will crystal reports take both of those formats?  Once I decide on a way to deliver the reports, then I can move forward on how to create them.
0
 
LVL 4

Expert Comment

by:BostonMA
Comment Utility
What I mean is, will you be physically running the reports for these people? Or will they have a copy of crystal reports on their desktop to run it? Or will you use another means...?
0
 

Author Comment

by:seanrhudy
Comment Utility
The accountant will be the only person that needs to print off these reports, so he would have crystal reports on his desktop.
0
 
LVL 4

Accepted Solution

by:
BostonMA earned 500 total points
Comment Utility
Then given everything you've said, crystal sounds like it will meet your needs...
0
 

Author Comment

by:seanrhudy
Comment Utility
Do I need crystal reports developer to initally create the reports?
0
 
LVL 4

Expert Comment

by:BostonMA
Comment Utility
Yes--how else were you thinking they would be created?
0
 

Author Comment

by:seanrhudy
Comment Utility
Not too familiar with crystal reports, that's all.  I will close this question and open a new one on how to actually create the report.  I will try to get as far as I can on my own though.  Thanks again for all the help.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Craigslist Software for Windows Computer 9 69
Dentrix G4 1 30
Salesforce Campaign - 4,500 members 5 47
Pull date to Group header 6 12
If your app took Google’s lash recently, here are the 5 most likely reasons.
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Viewers will learn how to use the Hootsuite Dashboard.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now