CCS Point of Sale
You are here: start » office » customer_relations_management » user_preferences
Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
office:customer_relations_management:user_preferences [2011/12/15 23:49] markphillips |
office:customer_relations_management:user_preferences [2018/12/23 12:11] (current) |
||
---|---|---|---|
Line 15: | Line 15: | ||
===== Reporting on the Fields ===== | ===== Reporting on the Fields ===== | ||
- | You may want to request help from CCS Staff, this section involves SQL Coding which most users are not familiar with.\\ | + | You may want to request help from CCS Staff, this section involves SQL Coding which most users are not familiar with. To use this feature, you would need to access [[office:reporting:pivot_reporting|Pivot Reporting]]\\ |
If you wanted to pull a report that showed when a patient first signed up, you would use a statement like this:\\ | If you wanted to pull a report that showed when a patient first signed up, you would use a statement like this:\\ | ||
Line 47: | Line 47: | ||
The report would yeild something like: | The report would yeild something like: | ||
- | John | Smith | 01/20/2011 | + | |John | Smith | 01/20/2011| |
- | Mary | Jane | 04/20/2011 | + | |Mary | Jane | 04/20/2011| |
- | Jim | Chough| 09/10/2011 | + | |Jim | Chough| 09/10/2011| |
Trace: