HELP! Need to export hourly sales data on POS (NOT RMS)

How can I export hourly sales data across a date range?  For instance, I 
want to show hourly sales for the month of October so I can graph it and 
post it in our break room.

If I can't export hourly data, can I export daily sales?

The built-in reports don't address this data format.



0
11/14/2007 9:25:39 PM
pos 14173 articles. 0 followers. Follow

8 Replies
642 Views

Similar Articles

[PageSpeed] 34

This is a multi-part message in MIME format.

------=_NextPart_000_008E_01C826DC.CBC512D0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

Mark, This should work for you. Keep in  mind it takes up to 5-10 minutes to 
load the sales data.
Craig

"Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in message 
news:uiicoTwJIHA.4228@TK2MSFTNGP02.phx.gbl...
> How can I export hourly sales data across a date range?  For instance, I 
> want to show hourly sales for the month of October so I can graph it and 
> post it in our break room.
>
> If I can't export hourly data, can I export daily sales?
>
> The built-in reports don't address this data format.
>
>
> 

------=_NextPart_000_008E_01C826DC.CBC512D0
Content-Type: application/octet-stream;
	name="Custom - Detailed Sales Report by Hour.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Custom - Detailed Sales Report by Hour.qrp"

//--- Report Summary --- //

Begin ReportSummary
   ReportType =3D reporttypeSales
   ReportTitle =3D "Detailed Sales Report"
   PageOrientation =3D pageorientationPortrait
   OutLineMode =3D True
   Groups =3D 1
   GroupDescription =3D ""
   DisplayLogo =3D True
   LogoFileName =3D "MyLogo.bmp"
   ProcedureCall =3D ""
   TablesQueried =3D <BEGIN>
      FROM     TransactionEntry INNER JOIN [Transaction] WITH(NOLOCK) ON =
TransactionEntry.TransactionNumber =3D [Transaction].TransactionNumber=20
         INNER JOIN  Batch WITH(NOLOCK) ON [Transaction].BatchNumber =3D =
Batch.BatchNumber=20
         LEFT JOIN   Item WITH(NOLOCK) ON TransactionEntry.ItemID =3D =
Item.ID=20
         LEFT JOIN   Department WITH(NOLOCK) ON Item.DepartmentID =3D =
Department.ID=20
         LEFT JOIN   Category WITH(NOLOCK) ON Item.CategoryID =3D =
Category.ID=20
         LEFT JOIN   Supplier WITH(NOLOCK) ON Item.SupplierID =3D =
Supplier.ID=20
         LEFT JOIN   ReasonCode AS ReasonCodeDiscount WITH(NOLOCK) ON =
TransactionEntry.DiscountReasonCodeID =3D ReasonCodeDiscount.ID=20
         LEFT JOIN   ReasonCode AS ReasonCodeTaxChange WITH(NOLOCK) ON =
TransactionEntry.TaxChangeReasonCodeID =3D ReasonCodeTaxChange.ID
         LEFT JOIN   ReasonCode AS ReasonCodeReturn WITH(NOLOCK) ON =
TransactionEntry.ReturnReasonCodeID =3D ReasonCodeReturn.ID
         LEFT JOIN	Register WITH(NOLOCK) ON Batch.RegisterID =3D =
Register.ID
         LEFT JOIN   Customer WITH(NOLOCK) ON [Transaction].CustomerID =
=3D Customer.ID
         LEFT JOIN   Cashier WITH(NOLOCK) ON [Transaction].CashierID =3D =
Cashier.ID
			LEFT JOIN   QuantityDiscount WITH(NOLOCK) ON =
TransactionEntry.QuantityDiscountID =3D QuantityDiscount.ID

<END>

   SelCriteria =3D ""
   GroupBy =3D ""
   SortOrder =3D ""
End ReportSummary


//--- Title Rows ---//

Begin TitleRow
   Text =3D "<Store Name>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 16
   Color =3D "Blue"
End TitleRow

Begin TitleRow
   Text =3D "<Report Title>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 12
   Color =3D "Black"
End TitleRow

Begin TitleRow
   Text =3D "Generated On <Report Date>"
   Font =3D "Arial"
   FontBold =3D True
   FontSize =3D 10
   Color =3D "Black"
End TitleRow


//--- Filters ---//

Begin Filter
   FieldName =3D "TransactionTime"
   FilterOp =3D reportfilteropBetween
   FilterLoLim =3D "<Today>"
   FilterHilim =3D "<Today>"
End Filter


//--- Columns ---//

Begin Column
   FieldName =3D "TimeSold"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Time Sold"
   VBDataType =3D vbString
   Formula =3D "cast(DatePart(Hh,[Transaction].Time) as nvarchar)+ =
':00'"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Department.Name"
   DrillDownFieldName =3D "Department.Name"
   DrillDownReportName =3D ""
   Title =3D "Department"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2205
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Category.Name"
   DrillDownFieldName =3D "Category.Name"
   DrillDownReportName =3D ""
   Title =3D "Category"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1515
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Supplier.SupplierName"
   DrillDownFieldName =3D "Supplier.SupplierName"
   DrillDownReportName =3D ""
   Title =3D "Supplier"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 825
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.ItemLookupCode"
   DrillDownFieldName =3D "Item.ItemLookupCode"
   DrillDownReportName =3D ""
   Title =3D "Item"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1380
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.BinLocation"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Bin Location"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1140
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.Description"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Description"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2115
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Item.WebItem"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Web Item"
   VBDataType =3D vbBoolean
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1057
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
   FieldName =3D "Item.Quantity"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "On Hand"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 810
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.Price"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 555
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceA"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price A"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 720
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceB"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price B"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 660
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.PriceC"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price C"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 720
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.SalePrice"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sale Price"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 945
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.MSRP"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "MSRP"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 945
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.SaleStartDate"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sale Starts"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1020
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.SaleEndDate"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sale Ends"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 930
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Item.LastSold"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Last Sold"
   VBDataType =3D vbDate
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "TransactionEntry.Quantity"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Qty Sold"
   VBDataType =3D vbDouble
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 810
   GroupMethod =3D groupmethodSum
   ColFormat =3D "#.##"
End Column

Begin Column
   FieldName =3D "TransactionEntry.Price"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Sold Price"
   VBDataType =3D vbCurrency
   Formula =3D ""
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 970
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Total"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Total Sales"
   VBDataType =3D vbCurrency
   Formula =3D "TransactionEntry.Price * TransactionEntry.Quantity"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1275
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "[Transaction].TransactionNumber"
   DrillDownFieldName =3D "[Transaction].TransactionNumber"
   DrillDownReportName =3D ""
   Title =3D "Transaction"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1245
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "TransactionTime"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   StoreIDFieldName =3D ""
   Title =3D "Date Sold"
   VBDataType =3D vbDate
   Formula =3D "CONVERT(datetime, CONVERT(nvarchar, [Transaction].Time, =
101), 101)"
   ColHidden =3D False
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "TransactionEntry.Cost"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Cost"
   VBDataType =3D vbCurrency
   Formula =3D "TransactionEntry.Quantity * TransactionEntry.Cost"
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "Profit"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Profit"
   VBDataType =3D vbCurrency
   Formula =3D "(TransactionEntry.Price - TransactionEntry.Cost) * =
TransactionEntry.Quantity"
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodSum
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "ProfitMargin"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Profit Margin"
   VBDataType =3D vbDouble
   Formula =3D "CASE WHEN TransactionEntry.Price <> 0 THEN CASE WHEN =
TransactionEntry.Quantity > 0 THEN (TransactionEntry.Price - =
TransactionEntry.Cost) / TransactionEntry.Price ELSE CASE WHEN =
TransactionEntry.Quantity < 0 THEN (TransactionEntry.Price - =
TransactionEntry.Cost) / (TransactionEntry.Price*-1) ELSE 0 END END ELSE =
0 END"
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 900
   GroupMethod =3D groupmethodAverage
   ColFormat =3D "0.00%"
End Column

Begin Column
   FieldName =3D "ReasonCodeDiscount.Description"
   DrillDownFieldName =3D "Reasoncode.Description"
   DrillDownReportName =3D ""
   Title =3D "Discount Reason Code"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2280
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "ReasonCodeTaxChange.Description"
   DrillDownFieldName =3D "Reasoncode.Description"
   DrillDownReportName =3D ""
   Title =3D "Tax Change Reason Code"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2280
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "ReasonCodeReturn.Description"
   DrillDownFieldName =3D "Reasoncode.Description"
   DrillDownReportName =3D ""
   Title =3D "Return Reason Code"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2280
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "PriceSource"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Price Source"
   VBDataType =3D vbString
   Formula =3D "CASE TransactionEntry.PriceSource WHEN 1 THEN 'Regular =
Price' WHEN 2 THEN (CASE WHEN TransactionEntry.QuantityDiscountID <> 0 =
THEN QuantityDiscount.Description ELSE 'Quantity Discount' END) WHEN 3 =
THEN 'Buydown Discount' WHEN 4 THEN 'Price Level Disc.' WHEN 5 THEN =
'Sale Price' WHEN 6 THEN 'Disc. from Reg. Price' WHEN 7 THEN 'Disc. from =
Cur. Price' WHEN 8 THEN 'Cost Markup Disc.' WHEN 9 THEN 'Profit Margin =
Disc.' WHEN 10 THEN 'Cashier Set' WHEN 11 THEN 'Component'  WHEN 12 THEN =
'Price Level A Disc.' WHEN 13 THEN 'Price Level B Disc.' WHEN 14 THEN =
'Price Level C Disc.'  WHEN 15 THEN 'Disc. from Reg. Price' WHEN 16 THEN =
'Disc. from Cur. Price' WHEN 17 THEN 'Cost Markup Disc.' WHEN 18 THEN =
'Profit Margin Disc.' ELSE 'Unknown' END"
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 2280
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Register.Number"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Register"
   VBDataType =3D vbLong
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1245
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
End Column

Begin Column
   FieldName =3D "CustomerName"
   DrillDownFieldName =3D ""
   DrillDownReportName =3D ""
   Title =3D "Customer"
   VBDataType =3D vbString
   Formula =3D "Customer.LastName + ', ' + Customer.FirstName"
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1350
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
   FieldName =3D "Customer.AccountNumber"
   DrillDownFieldName =3D "Customer.AccountNumber"
   DrillDownReportName =3D ""
   Title =3D "Account #"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1035
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column


Begin Column
   FieldName =3D "Cashier.Name"
   DrillDownFieldName =3D "Cashier.Name"
   DrillDownReportName =3D ""
   Title =3D "Cashier"
   VBDataType =3D vbString
   Formula =3D ""
   ColHidden =3D True
   ColNotDisplayable =3D False
   FilterDisabled =3D False
   ColWidth =3D 1350
   GroupMethod =3D groupmethodNone
   ColFormat =3D ""
   ColAlignment =3D flexAlignLeftCenter
End Column
------=_NextPart_000_008E_01C826DC.CBC512D0--

0
craig6967 (916)
11/14/2007 9:38:33 PM
Craig,

You advised placing the attached .qrp file in my Reports folder under the 
Microsoft Point of Sale directory; however, there is no Reports folder under 
that directory.  How do I import this custom report?

All my default reports are .xml files.

Remember, this is Point of Sale, not RMS or RMS POS.

Mark


"Craig" <craig@cctropicalparadisepets.com> wrote in message 
news:DEF3A277-6EBE-43B1-89CA-6A47867796D3@microsoft.com...
> Mark, This should work for you. Keep in  mind it takes up to 5-10 minutes 
> to
> load the sales data.
> Craig
>
> "Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in message
> news:uiicoTwJIHA.4228@TK2MSFTNGP02.phx.gbl...
>> How can I export hourly sales data across a date range?  For instance, I
>> want to show hourly sales for the month of October so I can graph it and
>> post it in our break room.
>>
>> If I can't export hourly data, can I export daily sales?
>>
>> The built-in reports don't address this data format.
>>
>>
>>
> 


0
11/14/2007 11:24:46 PM
"Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in
news:#zSQMWxJIHA.1208@TK2MSFTNGP05.phx.gbl: 

> Craig,
> 
> You advised placing the attached .qrp file in my Reports folder under
> the Microsoft Point of Sale directory; however, there is no Reports
> folder under that directory.  How do I import this custom report?
> 
> All my default reports are .xml files.
> 
> Remember, this is Point of Sale, not RMS or RMS POS.
> 
> Mark
> 
You will need to provide way more info then you have!
Product Name, Version # is the min.

The other would be what operating system, and some basic structure of 
directories will be required.

You may need to contact the manufacturer of the POS software for real 
help....remember you get what you pay for!

www.genesis-pos.com
Perishable Scale Software for RMS

> 
> "Craig" <craig@cctropicalparadisepets.com> wrote in message 
> news:DEF3A277-6EBE-43B1-89CA-6A47867796D3@microsoft.com...
>> Mark, This should work for you. Keep in  mind it takes up to 5-10
>> minutes to
>> load the sales data.
>> Craig
>>
>> "Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in message
>> news:uiicoTwJIHA.4228@TK2MSFTNGP02.phx.gbl...
>>> How can I export hourly sales data across a date range?  For
>>> instance, I want to show hourly sales for the month of October so I
>>> can graph it and post it in our break room.
>>>
>>> If I can't export hourly data, can I export daily sales?
>>>
>>> The built-in reports don't address this data format.
>>>
>>>
>>>
>> 
> 
> 
> 

0
11/15/2007 1:33:00 AM
Okay.

I am using MICROSOFT POINT OF SALE v.1.0 Binaries Version 2.0.1112.0

I am NOT using MICROSOFT RETAIL MANAGEMENT SYSTEM.

I want to create or import a report I can export to Excel.  This report 
should itemize sales by hour in a given range (for example, one day, one 
week or one month).

I was provided by respondent Craig a .QRP file containing a query for 
producing a report such as I require; however, instructions for using the 
..QRP file directed me to paste the file into the Reports folder withint the 
Point of Sale folder on the same hard drive on which POINT OF SALE is 
installed.  MICROSOFT POINT OF SALE does NOT have a folder titled Reports 
(installed folders are: Addins, Backups, Content, Database, eLearning, Logs, 
OPOS, Refresh, and Temp --- no subfolders titled Reports either), and the 
default reports included with the product are .XML files, not .QRP files.

When we run our X Report, sales by hour is included at the base of the 
report.  We can view via the POS application sales by hour for any date 
simply by changing the date parameter to the given date we wish to view. 
What I require is a method to export such hourly sales data in a format I 
can import into Excel for producing at-a-glance graphs.

If POINT OF SALE can display this info when you enter the appropriate date, 
how do I export this data?


> You will need to provide way more info then you have!
> Product Name, Version # is the min.
>
> The other would be what operating system, and some basic structure of
> directories will be required.
>
> You may need to contact the manufacturer of the POS software for real
> help....remember you get what you pay for!
>
> www.genesis-pos.com
> Perishable Scale Software for RMS
>


0
11/15/2007 3:03:44 AM
This is a multi-part message in MIME format.

------=_NextPart_000_0283_01C826F2.61166D60
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Mark,

Its been a while since I've looked at MSPOS because it doesn't run on =
Vista 64 bit, but it looks like you can semi-create the report you are =
looking for by day, broken down by department, but not by the hour.

Try Reports | Sales | Department Sales | select your date(s) on the left =
| Refresh | Collapse Grouped Rows on the menu | Export | to Microsoft =
Excel on the top menu

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in message =
news:uiicoTwJIHA.4228@TK2MSFTNGP02.phx.gbl...
  How can I export hourly sales data across a date range?  For instance, =
I=20
  want to show hourly sales for the month of October so I can graph it =
and=20
  post it in our break room.

  If I can't export hourly data, can I export daily sales?

  The built-in reports don't address this data format.



------=_NextPart_000_0283_01C826F2.61166D60
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16546" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Mark,</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Its been a while since =
I've looked at=20
MSPOS because it doesn't run on Vista 64 bit, but it looks like you can=20
semi-create the report you are looking for by day, broken down by =
department,=20
but not by the hour.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Try Reports | Sales | =
Department=20
Sales | select your date(s) on the left | Refresh | Collapse Grouped =
Rows on the=20
menu | Export | to Microsoft Excel on the top menu</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Mark Kalmus" &lt;<A=20
  =
href=3D"mailto:dogtoothcoffee@gmail.com">dogtoothcoffee@gmail.com</A>&gt;=
 wrote=20
  in message <A=20
  =
href=3D"news:uiicoTwJIHA.4228@TK2MSFTNGP02.phx.gbl">news:uiicoTwJIHA.4228=
@TK2MSFTNGP02.phx.gbl</A>...</DIV>How=20
  can I export hourly sales data across a date range?&nbsp; For =
instance, I=20
  <BR>want to show hourly sales for the month of October so I can graph =
it and=20
  <BR>post it in our break room.<BR><BR>If I can't export hourly data, =
can I=20
  export daily sales?<BR><BR>The built-in reports don't address this =
data=20
  format.<BR><BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0283_01C826F2.61166D60--

0
cptsoft (1248)
11/15/2007 3:13:03 AM
This is a multi-part message in MIME format.

------=_NextPart_000_02F9_01C82701.0CBDB930
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_02FA_01C82701.0CBDB930"


------=_NextPart_001_02FA_01C82701.0CBDB930
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Mark,

To answer your other question about creating reports, how's your XML?=20

To add a new report, properly written in .XML for MSPOS, Manager | Tools =
| File Center | Reports | Custom | Add File.

If you want to modify an existing report, find it in the same place and =
select which report you want to customize.  Select the Save File menu =
and save it to your desired location.  Modify and rename it and add it =
back to the Custom section described above.  Do not save a modified =
report file as the same name as it was, otherwise it will be overwritten =
with the next MSPOS update.


As you have found out, most people are using RMS in this newsgroup and =
some don't even know about the MSPOS program's existence. Continue to =
post in the Subject line and within the post itself that you are using =
MSPOS, but understand that some will still post references to RMS. Just =
ignore them.

Next year with RMS 3.0, there will more compatibility and knowledge =
about the MSPOS program as RMS will be a enhanced version of what you =
have, but I would suggest that you think about upgrading to the MSPOS =
3.0 product when it arrives also next year. Should be around the same =
timeframe. =20

Before all of you lurkers reading this message ask, we still haven't =
been told as to when it will ship, but I'm betting on a January =
announcement with an April ship date, same as this year.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in message =
news:ujM8iQzJIHA.5928@TK2MSFTNGP05.phx.gbl...

  Okay.

  I am using MICROSOFT POINT OF SALE v.1.0 Binaries Version 2.0.1112.0

  I am NOT using MICROSOFT RETAIL MANAGEMENT SYSTEM.

  I want to create or import a report I can export to Excel.  This =
report=20
  should itemize sales by hour in a given range (for example, one day, =
one=20
  week or one month).

  I was provided by respondent Craig a .QRP file containing a query for=20
  producing a report such as I require; however, instructions for using =
the=20
  .QRP file directed me to paste the file into the Reports folder =
withint the=20
  Point of Sale folder on the same hard drive on which POINT OF SALE is=20
  installed.  MICROSOFT POINT OF SALE does NOT have a folder titled =
Reports=20
  (installed folders are: Addins, Backups, Content, Database, eLearning, =
Logs,=20
  OPOS, Refresh, and Temp --- no subfolders titled Reports either), and =
the=20
  default reports included with the product are .XML files, not .QRP =
files.

  When we run our X Report, sales by hour is included at the base of the =

  report.  We can view via the POS application sales by hour for any =
date=20
  simply by changing the date parameter to the given date we wish to =
view.=20
  What I require is a method to export such hourly sales data in a =
format I=20
  can import into Excel for producing at-a-glance graphs.

  If POINT OF SALE can display this info when you enter the appropriate =
date,=20
  how do I export this data?


  > You will need to provide way more info then you have!
  > Product Name, Version # is the min.
  >
  > The other would be what operating system, and some basic structure =
of
  > directories will be required.
  >
  > You may need to contact the manufacturer of the POS software for =
real
  > help....remember you get what you pay for!
  >
  > www.genesis-pos.com
  > Perishable Scale Software for RMS
  >


------=_NextPart_001_02FA_01C82701.0CBDB930
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16546" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Mark,</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>To answer your other =
question about=20
creating reports, how's your XML? <IMG title=3D"Smile emoticon"=20
style=3D"FLOAT: none; MARGIN: 0px; POSITION: static" tabIndex=3D-1=20
alt=3D"Smile emoticon" =
src=3D"cid:E996C285AE8F48188D978F8F25B39715@JeffVista64"=20
MSNNonUserImageOrEmoticon=3D"true"></FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>To add a new report, =
properly written=20
in .XML&nbsp;for MSPOS, Manager | Tools | File Center |&nbsp;Reports | =
Custom |=20
Add File.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>If you want to modify =
an existing=20
report, find it in the same place and select which report you want to=20
customize.&nbsp; Select the Save File menu and save it to your desired=20
location.&nbsp; Modify and rename it and add it back to the Custom =
section=20
described above.&nbsp; Do not save a modified report file as the same =
name as it=20
was, otherwise it will be overwritten with the next MSPOS =
update.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>As you have found out, =
most people=20
are using RMS in this newsgroup and some don't even know about the MSPOS =

program's existence. Continue to post in the Subject line and within the =
post=20
itself that you are using MSPOS, but understand that some will still =
post=20
references to RMS. Just ignore them.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Next year with RMS 3.0, =
there will=20
more compatibility and knowledge about the MSPOS program as RMS will be =
a=20
enhanced version of what you have, but I would suggest that you think =
about=20
upgrading to the MSPOS 3.0 product when it arrives also next year. =
Should be=20
around the same timeframe.&nbsp; </FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Before all of you =
lurkers reading=20
this message ask, we still haven't been told as to when it will ship, =
but I'm=20
betting on a January announcement with an April&nbsp;ship date, same as =
this=20
year.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Mark Kalmus" &lt;<A=20
  =
href=3D"mailto:dogtoothcoffee@gmail.com">dogtoothcoffee@gmail.com</A>&gt;=
 wrote=20
  in message <A=20
  =
href=3D"news:ujM8iQzJIHA.5928@TK2MSFTNGP05.phx.gbl">news:ujM8iQzJIHA.5928=
@TK2MSFTNGP05.phx.gbl</A>...</DIV><BR>Okay.<BR><BR>I=20
  am using MICROSOFT POINT OF SALE v.1.0 Binaries Version =
2.0.1112.0<BR><BR>I am=20
  NOT using MICROSOFT RETAIL MANAGEMENT SYSTEM.<BR><BR>I want to create =
or=20
  import a report I can export to Excel.&nbsp; This report <BR>should =
itemize=20
  sales by hour in a given range (for example, one day, one <BR>week or =
one=20
  month).<BR><BR>I was provided by respondent Craig a .QRP file =
containing a=20
  query for <BR>producing a report such as I require; however, =
instructions for=20
  using the <BR>.QRP file directed me to paste the file into the Reports =
folder=20
  withint the <BR>Point of Sale folder on the same hard drive on which =
POINT OF=20
  SALE is <BR>installed.&nbsp; MICROSOFT POINT OF SALE does NOT have a =
folder=20
  titled Reports <BR>(installed folders are: Addins, Backups, Content, =
Database,=20
  eLearning, Logs, <BR>OPOS, Refresh, and Temp --- no subfolders titled =
Reports=20
  either), and the <BR>default reports included with the product are =
..XML files,=20
  not .QRP files.<BR><BR>When we run our X Report, sales by hour is =
included at=20
  the base of the <BR>report.&nbsp; We can view via the POS application =
sales by=20
  hour for any date <BR>simply by changing the date parameter to the =
given date=20
  we wish to view. <BR>What I require is a method to export such hourly =
sales=20
  data in a format I <BR>can import into Excel for producing at-a-glance =

  graphs.<BR><BR>If POINT OF SALE can display this info when you enter =
the=20
  appropriate date, <BR>how do I export this data?<BR><BR><BR>&gt; You =
will need=20
  to provide way more info then you have!<BR>&gt; Product Name, Version =
# is the=20
  min.<BR>&gt;<BR>&gt; The other would be what operating system, and =
some basic=20
  structure of<BR>&gt; directories will be required.<BR>&gt;<BR>&gt; You =
may=20
  need to contact the manufacturer of the POS software for real<BR>&gt;=20
  help....remember you get what you pay for!<BR>&gt;<BR>&gt; <A=20
  href=3D"http://www.genesis-pos.com">www.genesis-pos.com</A><BR>&gt; =
Perishable=20
  Scale Software for RMS<BR>&gt;<BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_02FA_01C82701.0CBDB930--

------=_NextPart_000_02F9_01C82701.0CBDB930
Content-Type: image/gif;
	name="Emoticon1.gif"
Content-Transfer-Encoding: base64
Content-ID: <E996C285AE8F48188D978F8F25B39715@JeffVista64>

R0lGODlhEwATALMPAPXv3v3pTvDHOei2K9u4a9qoLunPkLGLMdOZKfvbQMeyl5p4J+7JbrebXoAy
GAAAACH5BAEAAA8ALAAAAAATABMAAASu8EkJDBNjMAOmf5UgJEGQJBj3AVfpuslAdBRDvu8p04YQ
CIuFrzQIDgQFA2i4AAAWruYTgwiVFopnNCsUICy3hUMBvY67hcYwIHaU2Q43ZnAYuIDCUixYmC8G
NzgmJyIZBQcXgYMnKIUDCA09jA4FgCcFCA4ZdFlHl5SbmQiGBx0GR0iZcXEIo5wUBH1ImK2tGQcN
NCCxm70Dh7krBq2VvwgHB1kfExUNBwu4yh4RADs=

------=_NextPart_000_02F9_01C82701.0CBDB930--

0
cptsoft (1248)
11/15/2007 4:58:04 AM
Jeff,

My XML is passable, and I can use other reports as a template.  The 
impediment is locating which tables house the info I want.  I've searched 
the database schema using sp_help but remain unable to find how the hourly 
sales info is pulled when you select F7 | Graph | Hourly.


"Jeff @ Check Point Software" <cptsoft@hotmail.com> wrote in message 
news:%23xBzcQ0JIHA.3400@TK2MSFTNGP03.phx.gbl...
Mark,

To answer your other question about creating reports, how's your XML?

To add a new report, properly written in .XML for MSPOS, Manager | Tools | 
File Center | Reports | Custom | Add File.

If you want to modify an existing report, find it in the same place and 
select which report you want to customize.  Select the Save File menu and 
save it to your desired location.  Modify and rename it and add it back to 
the Custom section described above.  Do not save a modified report file as 
the same name as it was, otherwise it will be overwritten with the next 
MSPOS update.


As you have found out, most people are using RMS in this newsgroup and some 
don't even know about the MSPOS program's existence. Continue to post in the 
Subject line and within the post itself that you are using MSPOS, but 
understand that some will still post references to RMS. Just ignore them.

Next year with RMS 3.0, there will more compatibility and knowledge about 
the MSPOS program as RMS will be a enhanced version of what you have, but I 
would suggest that you think about upgrading to the MSPOS 3.0 product when 
it arrives also next year. Should be around the same timeframe.

Before all of you lurkers reading this message ask, we still haven't been 
told as to when it will ship, but I'm betting on a January announcement with 
an April ship date, same as this year.

-- 

Jeff
Check Point Software 


0
11/15/2007 5:48:46 PM
This is a multi-part message in MIME format.

------=_NextPart_000_005C_01C82776.AC531790
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Mark,

The comes from the Time column of the Transaction table.

Look at the RMS report that Craig sent for a hints/clues on how the info =
is retrieved and calculated, first 2 columns.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "Mark Kalmus" <dogtoothcoffee@gmail.com> wrote in message =
news:u%23$kG$6JIHA.4592@TK2MSFTNGP02.phx.gbl...
  Jeff,

  My XML is passable, and I can use other reports as a template.  The=20
  impediment is locating which tables house the info I want.  I've =
searched=20
  the database schema using sp_help but remain unable to find how the =
hourly=20
  sales info is pulled when you select F7 | Graph | Hourly.


  "Jeff @ Check Point Software" <cptsoft@hotmail.com> wrote in message=20
  news:%23xBzcQ0JIHA.3400@TK2MSFTNGP03.phx.gbl...
  Mark,

  To answer your other question about creating reports, how's your XML?

  To add a new report, properly written in .XML for MSPOS, Manager | =
Tools |=20
  File Center | Reports | Custom | Add File.

  If you want to modify an existing report, find it in the same place =
and=20
  select which report you want to customize.  Select the Save File menu =
and=20
  save it to your desired location.  Modify and rename it and add it =
back to=20
  the Custom section described above.  Do not save a modified report =
file as=20
  the same name as it was, otherwise it will be overwritten with the =
next=20
  MSPOS update.


  As you have found out, most people are using RMS in this newsgroup and =
some=20
  don't even know about the MSPOS program's existence. Continue to post =
in the=20
  Subject line and within the post itself that you are using MSPOS, but=20
  understand that some will still post references to RMS. Just ignore =
them.

  Next year with RMS 3.0, there will more compatibility and knowledge =
about=20
  the MSPOS program as RMS will be a enhanced version of what you have, =
but I=20
  would suggest that you think about upgrading to the MSPOS 3.0 product =
when=20
  it arrives also next year. Should be around the same timeframe.

  Before all of you lurkers reading this message ask, we still haven't =
been=20
  told as to when it will ship, but I'm betting on a January =
announcement with=20
  an April ship date, same as this year.

  --=20

  Jeff
  Check Point Software=20


------=_NextPart_000_005C_01C82776.AC531790
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<META content=3D"MSHTML 6.00.6000.16546" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Mark,</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>The&nbsp;comes from =
the&nbsp;Time=20
column of the Transaction table.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2>Look at the RMS report =
that Craig=20
sent for a hints/clues on how the info is retrieved and calculated, =
first 2=20
columns.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#008000 size=3D2></FONT><BR>-- =
<BR><BR>Jeff <BR>Check=20
Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Mark Kalmus" &lt;<A=20
  =
href=3D"mailto:dogtoothcoffee@gmail.com">dogtoothcoffee@gmail.com</A>&gt;=
 wrote=20
  in message <A=20
  =
href=3D"news:u%23$kG$6JIHA.4592@TK2MSFTNGP02.phx.gbl">news:u%23$kG$6JIHA.=
4592@TK2MSFTNGP02.phx.gbl</A>...</DIV>Jeff,<BR><BR>My=20
  XML is passable, and I can use other reports as a template.&nbsp; The=20
  <BR>impediment is locating which tables house the info I want.&nbsp; =
I've=20
  searched <BR>the database schema using sp_help but remain unable to =
find how=20
  the hourly <BR>sales info is pulled when you select F7 | Graph |=20
  Hourly.<BR><BR><BR>"Jeff @ Check Point Software" &lt;<A=20
  href=3D"mailto:cptsoft@hotmail.com">cptsoft@hotmail.com</A>&gt; wrote =
in message=20
  <BR><A=20
  title=3D"news:%23xBzcQ0JIHA.3400@TK2MSFTNGP03.phx.gbl&#10;CTRL + Click =
to follow link"=20
  =
href=3D"news:%23xBzcQ0JIHA.3400@TK2MSFTNGP03.phx.gbl">news:%23xBzcQ0JIHA.=
3400@TK2MSFTNGP03.phx.gbl</A>...<BR>Mark,<BR><BR>To=20
  answer your other question about creating reports, how's your =
XML?<BR><BR>To=20
  add a new report, properly written in .XML for MSPOS, Manager | Tools =
|=20
  <BR>File Center | Reports | Custom | Add File.<BR><BR>If you want to =
modify an=20
  existing report, find it in the same place and <BR>select which report =
you=20
  want to customize.&nbsp; Select the Save File menu and <BR>save it to =
your=20
  desired location.&nbsp; Modify and rename it and add it back to =
<BR>the Custom=20
  section described above.&nbsp; Do not save a modified report file as =
<BR>the=20
  same name as it was, otherwise it will be overwritten with the next =
<BR>MSPOS=20
  update.<BR><BR><BR>As you have found out, most people are using RMS in =
this=20
  newsgroup and some <BR>don't even know about the MSPOS program's =
existence.=20
  Continue to post in the <BR>Subject line and within the post itself =
that you=20
  are using MSPOS, but <BR>understand that some will still post =
references to=20
  RMS. Just ignore them.<BR><BR>Next year with RMS 3.0, there will more=20
  compatibility and knowledge about <BR>the MSPOS program as RMS will be =
a=20
  enhanced version of what you have, but I <BR>would suggest that you =
think=20
  about upgrading to the MSPOS 3.0 product when <BR>it arrives also next =
year.=20
  Should be around the same timeframe.<BR><BR>Before all of you lurkers =
reading=20
  this message ask, we still haven't been <BR>told as to when it will =
ship, but=20
  I'm betting on a January announcement with <BR>an April ship date, =
same as=20
  this year.<BR><BR>-- <BR><BR>Jeff<BR>Check Point Software=20
<BR><BR></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_005C_01C82776.AC531790--

0
cptsoft (1248)
11/15/2007 7:00:03 PM
Reply:

Similar Artilces:

macro needed
hello listers to begin with i have no great excel skills what I am looking for is a macro that I can easily use to send mail to a list of users I have made a web page that students sign up on http://biosciences.utoledo.edu/prs enter there info when they press submit the data is saved to a text file that can be opened as a csv file in excel I would like to have a macro go row by row down the page and extract the email from column G and insert that in to an email and also the students name from coulmn B. The csv file is set up like this ID Fname Lname StudentID TransmitID Section e...

Export WPX4 Address book to MS Word 2007?
Is it possible to transfer my WordPerfect X4 address book to Word 2007 for use in addressing envelopes etc.? I have the home and school version of 07. Thanks, Rich Mercer Word doesn't have an address book. It utilises the contacts list of Outlook, which of course the student version of Office does not include. It *may* be possible to extract the data from your WP address book to a Word table to use as a data source for mail merge, but I suspect you may have to do this from Word Perfect. If you still have access to WP, check if it has an option to export to a comma delim...

Need VB code to edit cell values
I need some VB to do the following please (My VB is not good enough yet) Starting from the active cell (call it the StartCell) In the cell to the left.. ThreeChars = Value.right(3) (the last three chars) Value = Value - last three characters (assume value is text & at least 3 chars present) In StartCell.. value = ThreeChars (as text, overwrite any contents of StartCell) move active cell one down from StartCell Examples of before/after -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Stephen Ford" <Stephen_Ford_no@spam_uwclub....

merging into Word with filtered data
Hello, I'm trying to do a merge in Word using data from Excel. However, I don't want to merge using data from the whole worksheet, but just filtered data (all people from London - place is one of the fields in the worksheet. I have no idea how I might do this. Any help gratefully received. I believe you can accomplish this from Word by using "Query Options" and selecting to merge only those records you're seeking. HTH PC "Italian Pete" <ItalianPete@discussions.microsoft.com> wrote in message news:3E62FCDC-42EC-48DB-92AC-857B224F085F@microsoft.c...

Data Loss in Publisher
Hi I run a W2k network in a school. I have Office Group Policies in place forcing the default save location for Publisher documents (Office XP version) to the pupil's home folders. All my PCs are identical (ghost images). Pupils have roaming profiles (some mandatory). Some users save work in Publisher and the next time they log on to the network and open the saved file, it's contents have gone! There is nothing exceptional about the affected users' user accounts and they have a mixture of mandatory and roaming profiles. Has anyone come across this problem before? Than...

merging 3 spreadsheets into one based upon a single common data field
OK I hope you guys can help me out. Here is the scenario. I have 3 spreadsheets. The main spreadsheet I working with has 500 lines with a unique number string. The next two spreadsheets have about 12000 lines but also contain the same unique string as the first spreadsheet. I want to search the 2nd and 3rd spreadsheet using the first spreadsheets unique id number and then take the information from the 2nd and 3rd spreadsheet and then merge it into the first. Does that make since? Any help would be great. -- xchosen --------------------------------------------------------------------...

Help Microsoft Office 2003
After now using Microsoft Office 2003 for about 3 months now, have suddenly noticed that my email messages have just started showing strange symbols for certain punctuation. This does not show as I type... but the recipent sees these symbols when the message is received. I can see it when they reply back. The strange symbols show for the apostrophe and sometimes for the exclaimation. I do not recognize the symbols. I do not have caps lock on, do have number lock on. None of the symbols show on my keys. Help?! Thanks! Kim it's caused by character encoding. What email client and...

Any way to clear out stock pricing data before or after going to Quicken?
With all the discussion a few months ago about taking control of our own data, I had gone through the steps to look at my Money file as an Access DB, and found that of my 80MB, more than half was daily stock prices. Thats not something I really want to convert and maintain. I can't imagine that its really needed, since transactions have their own price info. Is there any way to get rid of it in Money, in Quicken, or other? Thanks In Money Plus: Portfolio > Other Tasks > More > Clear historical quotes The process may be different in earlier versions. "JDelMar&q...

Export to Text Files Based on Field Value
I have an Access table with personal information (e.g., first name, last name, birth date, etc.) for thousands of people. The table is sorted by state. I want to be able to run a macro on that table that will create separate pipe delimited text files for each state with all fields included. Any help would be appreciated? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1 Instead of exporting the table, export a query based on the table. You will have to have some code that loops through the states and modifies the quer...

.pst folder help
How do I put a .pst folder in My Documents for constant up to date copying? Mine seems to be in a folder called Office Data File which I cannot open but do not see any pst file...can someone kindly help me out here? Thanks! Right click the pst in outlook and select properties and then click Advanced You will see the location of the file. Depending on your view settings it may be hidden. Close the pst, (right click it, close) Move the file to the location you desire. Open Outlook select File - Open - Outlook Data File Browse to the file and select it. OK Done Regards Mark Dormer &quo...

moving large amounts of data from one db to another
I have a table that has millions of rows of data in it, which then references another table with millions of referenced (matching by foreign key constraints)... I need to move this data from database A to a new database B, is there any way to do this and preserve the identity columns and their referential integrity?) Thanks! You can't have integrated RI across databases so that part is out. But you can certainly insert and keep the identities. Take a look at SET IDENTITY INSERT in BOL. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Smokey Grindel"...

Routing Engine not starting, please help ASAP
Exchange and Windows 2003 I cannot get the Exchange Routing engine to start up. Upon startup I get an event ID 7023 telling me that the path is not found. Everything else works and starts up just fine, people can open mailboxes, but cannot send/receive emails. I read online that it sounds like the metabase.bin file is corrupted. I uninstalled/reinstalled IIS, reinstalled Exchange 2003, and have reinstalled Exchange 2003 SP1, everything works except that I still cannot get the routing engine to kick back on. Any suggestions! Thanks! Was this an OEM preinstall? I recently bought a ser...

Help with macro to choose printer
Hi, I am new to macros in Excel and this is what I did to print a worksheet: ------------------------------------------------------------------------ Range("A1:W35").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$W$35" Selection.PrintOut From:=1, To:=1, Copies:=1, Collate:=True End Sub ------------------------------------------------------------------------ Works great except that I want to select the printer to use and the macro won't stop at the point to choose printer. Any way to work around this? Any help is greatly appreciated. Emilio Emilio,this wil...

Sales For Outlook 12-22-04
While reading in the MS-CRM book (installation and configuration), I understand some ideas I just want to be sure that I understand correctly: 1-When a user install sales for outlook client, a personal web server (PWS) is automatically installed, this PWS is used only when the user is offline for rendering the web pages. When the user is online (and using sales for outlook) the web server of the CRM server render the web pages not the PWS, is that true? 2-A copy of the aspx pages is moved to the client machine, when this copy happen?, it is happen each time the client disconnect from the...

Item's Last Sale Date
Hi there I'm creating a smartlist report that will display the item details but not sure which inventory table I should use to get the Last Sale date of an item. Any ideas? thanks. You can try this query to fetch the item number with the highest date of sale (or last sale date): SELECT ITEMNMBR, DOCDATE FROM IV10201 GROUP BY DOCDATE, ITEMNMBR HAVING DOCDATE =3D MAX(DOCDATE) AND ITEMNMBR =3D 'xxx' You can change 'xxx' with your item number. I've not tested this fully so you may want to run this in your environment and make sure that this query will work for every ...

Pulling data from multiple worksheets
I have one worksheet with a listing of client numbers and names. I would like to be able to type in a client number on another worksheet and have the client name automatically populate. Look at the Vlookup function or the combination of Index / Match. Vlookup will be a little more straight forward for a first timer but Index / Match is generally speaking a more flexible and less error prone solution. -- HTH... Jim Thomlinson "parthur" wrote: > I have one worksheet with a listing of client numbers and names. I would > like to be able to type in a clie...

Help with an expression to calculate a profit from one of three fi
Using Access 2003 SP3 - in Forms I know I'm probably asking a very complex question, so a very big THANK YOU to whomever can help. I am doing a detailed inventory and need help with an expression in my form that will calculate my profit based on one of three fields. Only one field would have the end data. To clarify what I am working with: Most stock items come by the "unit" and contain multiple "subunits" which, in turn, contain smaller "pieces." However, some "units" only come with "subunits" and some only come as &quo...

Highlighting Operating Hours
I have an XY scatter plot of temperature inside an office building throughout different times of day across a 3 week period. What I would like to see are coloured bars that highlight when the office is open (operating hours). I tried adding colour-filled rectangles with 50% transparency, but I am having printing issues. It looks fine on screen, but when I go to print the bars are scaled differently than the chart thus they don't line up properly. I think this might be a bug in Excel. This issue comes and goes; sometimes it prints OK, most of the time it doesn't (and I haven&#...

summarise data
I have data on a sheet looking like this 5/5/2004 5/5/2004 7/5/2004 7/5/2004 7/5/2004 7/5/2004 8/5/2004 9/5/2004 9/5/2004 9/5/2004 and I want to summarise this into different cells so that it look like 5/5/2004 7/5/2004 8/5/2004 9/5/2004 i.e. I want to list individual occurances of repeating dates o numbers. Any help would be much appreciated -- Message posted from http://www.ExcelForum.com Sounds like a job or a Pivot Table perhaps? http://www.ozgrid.com/Excel/excel-pivot-tables.htm ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore...

creating a program that uses data from a sensor....
Hello, I want to create an MFC program that uses parameter values passed to it from a meter (specifically the resistance in ohms of resisters in an electronic circuit). What are the hardware components that would be needed? And what MFC class(es) would I use to accomplish this? Thanks, RABMissouri2006 On 21 Oct 2006 08:10:50 -0700, "RAB" <rabmissouri@yahoo.com> wrote: >Hello, > >I want to create an MFC program that uses parameter values passed to it >from a meter (specifically the resistance in ohms of resisters in an >electronic circuit). What are the ha...

Data archive with GP Manufacturing
Has anyone had experience with any data archive with GP Manufacturing. The product from Professional Advantage does not support Manufacturing archive, at least not in the documentation. Don't have an answer for you but we will be doing the same in the next week or so. Will report back when done. "DavidInterDyn" wrote: > Has anyone had experience with any data archive with GP Manufacturing. The > product from Professional Advantage does not support Manufacturing archive, > at least not in the documentation. ...

Transfering Outlook Data to a New PC
I've just built a new PC. Currently it has nothing on it other than Windows. When I install Outlook 2003 I'll need to transfer the data from another PC onto it, including all folders, emails and attachments in them and calendar data. What's the easiest and most effective way to do this? Find the PST file and copy it to the new machine and into the appropriate directory, what? Thanks. Copy the pst(s) to the new PC There isnt an appropriate Folder, there is a default folder created when Outlook is installed. http://www.howto-outlook.com/howto/backupandrestore.htm "Marts&q...

Help with Lookup #2
I have an excel worksheet that has approximately 20,000+ records. I would like to classify these recorded based on two columns. The first column's name is "YB Description" and the other is "Sold Date". The YB column mainly contains 4 digit numerical values, with approximately 300-400 records that are text, ie. "classified", "not verified", "public use". The Sold Date column is pretty self-explanatory, all the records are dates with the following formatting - M/D/Y. What I would like to do is create a third column called YB/Sold that classi...

Locking of entered data
I haev a form that currently allows you to enter new records and edit existing records. My key field is based on a number entered by the user from another system. Once the number is entered I do not want the user to be able to type over that number but still be aloud to add a new record. I tried the AllowAdditions and AllowEdits in the properties but if I set them to Yes AllowAdditions and No AllowEdits then nothing can be changed. I want them to be able to edit everything but the one field containing the number. Ideas? Glenna, The code I provided would go in the two places that I...

Need a code
I need a code that does the following: If C3>D3, B3 value will start blink and if C3<D3, E3 value will start blink. Any help please. Thanks in advance. Personally, I would recommend against blinking text, but if you insist on employing it, this website should help you get started... http://www.cpearson.com/Excel/BlinkingText.aspx NOTE: Pay particular attention to the second of the two points delineated in the Summary section at the bottom of the webpage. -- Rick (MVP - Excel) "MAX" <MAX@discussions.microsoft.com> wrote in message news:C7E6...