• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 586
  • Last Modified:

Need software for retail door counter, maybe crystal reports.

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
Sean Rhudy
Asked:
Sean Rhudy
  • 8
  • 5
1 Solution
 
mlmccCommented:
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
 
Sean RhudyPresidentAuthor Commented:
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
 
Sean RhudyPresidentAuthor Commented:
All exports in the Edge POS software are in csv format.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
BostonMACommented:
How about just a stored procedure on a server which you schedule and have it email whoever you need to notify....
0
 
Sean RhudyPresidentAuthor Commented:
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
 
BostonMACommented:
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
 
Sean RhudyPresidentAuthor Commented:
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
 
Sean RhudyPresidentAuthor Commented:
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
 
BostonMACommented:
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
 
Sean RhudyPresidentAuthor Commented:
The accountant will be the only person that needs to print off these reports, so he would have crystal reports on his desktop.
0
 
BostonMACommented:
Then given everything you've said, crystal sounds like it will meet your needs...
0
 
Sean RhudyPresidentAuthor Commented:
Do I need crystal reports developer to initally create the reports?
0
 
BostonMACommented:
Yes--how else were you thinking they would be created?
0
 
Sean RhudyPresidentAuthor Commented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now