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
671 Views

Similar Articles

[PageSpeed] 18

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:

Help building a filter on a form
Okay, I downloaded the Issue database template and simplified it greatly. Now, I can't get the "search issues" form to work. I have the following controls on my search form: Application (dropdown list) TextSearch (text field) I'd like to modify the existing code so that when I make an entry and click the "search" button, it will make the form footer visible (where the "browse_all_issues" form is imbedded as a subform). That part works. But, the next lines set the filter and turn it on... Me.FormFooter.Visible = True DoCmd.Mo...

Importing data #5
Hello, I have a workbook in Excel 2003 that I need some advice on please. The data used in the spreadsheet is collected online into a CSV file, this CSV file is imported into Excel onto a "Raw Data" worksheet. From this raw data several other worksheets need to access this raw data to prepare the reports required. I have the first report sheet designed and it picks up the data from the Raw Data sheet. The problem I need help with is updating the raw data; when I download a new file from our web site and refresh the data import the report worksheet does not update correctly. Fo...

Append Query
I have a table "Rates" with the following data: StartDate: 5/15/08 End Date: 6/23/08 Rate: $53 StartDate: 6/24/08 End Date: 7/15/08 Rate: $86 StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99 I have another table "Transactions". I want to create an append query such that if I supply the StartDate and EndDate, the query will populate the "Transactons" table with date and rate data from the "Rates" table for each and every day within the date range. Example: If I supply the StartDate of 6/23/08 and the EndDate of 6/25/08, the query would pop...

Save or Export to CSV
Hello, I have a macro that i recorded that is intended to export (save) data from the active worksheet within a workbook to a CSV file. The problem i'm having is that the macro is saving the entire workbook to a CSV. My file name is even changing. Following is the code: ---------------------------------------------------------------- Sub SaveAsCSV() ' ' SaveAsCSV Macro ' Application.DisplayAlerts = False ActiveSheet.SaveAs Filename:= _ "Z:\Timesheet\Time Sheet 2009.csv" _ , FileFormat:=xlCSV, CreateBackup:=False Applic...

Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or Query into specific cells of a Worksheet. The table I'm importing will always contain a single record only. For example, I'd like to export data from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc. Any sugestions would be most appreciative. ...

How to combine/consolidate data
Hi, I am about to create an Excel file that should be used by custmers to place orders. On the first sheet, I would like to have a summary of the entire order, so the customer can see what he ordered. All data is organized in same sort of tables accross several sheets - each sheet representing different product group. So, lets say I have table organized like below: ColumnA ColumnB ColumnC Product Price Order Prod1 10 1 Prod2 20 Prod3 20 2 And I have several of such tables on different sheets corresponding to each prodcut category. Now, on the first sheet, I w...

Traspose Column data into Row
Hi, I want to transpose column data in to row. I have seen many posts (using INDEX or OFFSET functions) but all these solution assume a fixed block of data to be transposed, My problem is that the data i have not only has variable blocks to be transposed but also has some duplicate headings(headings are duplicate but the data in front of each heading has different value. Below is the example of data Col A Col B Col C PRODUCT COST COMPONENT COST$ A Raw Mat 10 A D L ...

Analysing data from several excel workbooks
Hi, I'm totally new to excel and i need to analyse the changes in a funding position across several years in a seperate excel sheet. As in, submissions are made year on year showing the amount of revenue spent on several different services. I need to be able to compare how those have moved over the last 5 years in a single spreadsheet. I appreciate any help. Thanks To give a clear answer we would need a bit more detail of the data layout Give us a simplified version of what the data looks like Your 'subject' talks about different workBOOKS but the text of the ...

Conditional Formatting
I have a row of cells that calculate the totals for their columns but I force to be blank via IF statements until certain conditions are met. Once these conditions are met, the total appears. I'd like to also highlight these total cells via conditional formatting. My conditional formatting input is simply "If Cell is Greater than 0, format". For some reason all the cells format as though they are all > 0 yet they don't display anything. Are there some internal rules that specifiy when a cell is really 0? Is there another way to do this that won't care what the for...

MSCRM Reports Export format
Does anyone know if there is a way to export reports as Rich Text Format (*.rtf)? or exporting to a CSV? We have a customer that still uses Wordperfect, and exporting to an Excel or Word Doc may not be an option. ...

All help is worthy
I have set up a simple database in excel, using barcodes (i found this easier to scan and lookup, than access) plus the people working with this will find it simple to use. I have however reached a giant full stop. The database is pulled from Dave Peterson's update log worksheet, which works very well, the problems is that on a lookup sheet( using Vlookup ) where the user scans the barcode it will pull all info from the "database" sheet in reference to the barcode, ie: barcode number, surname,forename,address, early greenfees purchased,mid purchased,late. Is it possible to manipu...

IF Function Help
How do I write a command that says: =if(a1=1&b1=a number, c1/d1,"na") How do I write the "a number" part? Hi Flutie99 Try: =IF(A1=1,IF(ISNUMBER(B1)=TRUE,C1/D1,"na")) -- Sincerely, Michael Colvin "Flutie99" wrote: > How do I write a command that says: > > =if(a1=1&b1=a number, c1/d1,"na") > > How do I write the "a number" part? If I am reading your post correctly you want a cell to equal C1/D1 when A1=1 and B1= some some number and for the cell to = "na" otherwise =if(and(A1=1,B1=xx),C1/D1,&...

recovering data
Money 2000: Is there a way to recover data that was not backed up. I accidently deleted all deposits. When I used the restore file procedure all saved deposits were restored, but all deposits and withdrawals that hadn't been backed up were deleted. How can I get that work back? Thanks! Retype it all? I mean, seriously, if you type three pages to a document in Word that you last backed up a month ago, delete the three pages and then quit Word where are you? "ETHORN" <anonymous@discussions.microsoft.com> wrote in message news:e40d01c3f101$8989da00$a101280a@phx.gbl...

Managing Data Table
Hi, I need help to wrap the tex in Data Table. If any one knows how to do it, please let me know. Thanks for your help in advance. Yogesh Hi Yogesh What version of PowerPoint are you using? What kind of table is it and how did it get there (e.g. insert -> table, or a table connected with a graph)? If it's a graph, is it an Excel graph or an MSGraph graph? Lucy -- Lucy Thomson PowerPoint MVP MOS Master Instructor www.aneasiertomorrow.com.au "Yogesh" <Yogesh@discussions.microsoft.com> wrote in message news:F68FDA89-6289-4341-8886-54C580...

Publisher documents do not print. Help!
I just set up a new computer with an HP Deskjet 5440 and Microsoft Publisher 2003. Documents print perfectly from every software package except Publisher. Publisher documents don't print at all, even after I reinstalled the printer drivers. The entire document or just the pictures? If it is just the pictures, click the advanced print settings button in the print dialogue, graphics and fonts tab. Be sure "Do not print any graphics" is checked. Look on the HP site to be certain you have the most current driver. http://h10025.www1.hp.com/ewfrf/wc/softwareList?lc=en&cc=us...

Question with local vs. remote (Exchange server) data
Can someone please explain something basic to me about the way Outlook works. I'm a Mac user and not familiar with this thing but now need to figure out how to synchronize it with a PocketPC PDA device. We've got Outlook on our PCs (W2K), connected to an Exchange server. So, I see my calendar and contacts, which I know live on the server. But when I sync my device, it ends up empty. Is there some sort of "local" (to my PC) data that it's using instead of the Exchange server's info? If so, where is it and how do I find it? If I could find it, I could copy the Exchan...

Help in my VB Code .. to Delete
This is a multi-part message in MIME format. ------=_NextPart_000_0089_01C34629.B378D5B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi,=20 I have been trying to solve this problem since morning, and haven't = really come up with a solution. it is frustrating. please help. =20 i have a datagrid and got a delete column =20 <asp:datagrid id=3D"dgdocument" runat=3D"server" = AutoGenerateColumns=3D"False" EnableViewState=3D"True" = OnDeleteCommand=3D"DeleteCommand"> <Columns&...

Export memberships of all Exchange DLs
Is there a way that we can export all Exchange (2003, AD 2003) DLs and also view their memberships? Thanks! csvde.exe -f output.csv -r "(& (mailnickname=*) (| (&(objectClass=group)) ))" -l "member" "Fletcher" <iliketodirtbike@hotmail.com> wrote in message news:uP1pAhkdEHA.3916@TK2MSFTNGP11.phx.gbl... > Is there a way that we can export all Exchange (2003, AD 2003) DLs and also > view their memberships? > > Thanks! > > ...

HELP: Need To Print Better Quotes
I am having a terrible time being able to print a good looking quote from MS CRM. it either prints the plain quote (Address, amount..etc) or i can print the product list (With no address, or nothing).. is there anyway to print a normal quote as others do where you can have the company informaiton and also all of the products that they are buying listed there? one would think that is the most basic feature that is not there.. don't you guys think? ANY help you can provide will be appreciated.. Thanks Quoteless In DC :-) Add a customized quote via Reports using Crystal. >-----Origin...

forgot the password for Point of sale.
I have a client who forgot the password for Point of sale. How can I delete or find the password ? I Know that some people said that go to administration and do someting. But this Point of sale(RMS) dosen't have administration icon. It has only Microsoft Dynamics Point of Sale Icon. Open the file Rms.config, located in C:\Microsoft Dynamics - Point of Sale, with Notepad Change the line <initialized>True</initialized> to <initialized>False</initialized> Then start POS. You'll be prompted for store information, passwords etc, just as if it was t...

Help Everything is gone. It's all been deleted.
I went on excel last on Dec 5th and I saved before exiting as usual. When I opened the file today everything was gone. There is nothing there. The file it's saved as is still there but it's a new page. I don't know what to do. I need that information. HELP! Are you sure you opened the same workbook? What do you mean by "page"? Excel has pages only when you print. Do you mean a blank worksheet? Are there any other worksheets available or just the one blank one? Did you create a backup of the workbook when you saved? If you "need" the inf...

Bytes in Data Page Row
I am reading a book titled "Microsoft SQL Server 2008 Internals". In Chapter 6, which was authored by Kalen Delaney, Kimberly Tripp, and Paul Randall, the following table and Clustered Index is created: CREATE TABLE Employee( EmployeeID INT NOT NULL IDENTITY, LastName NCHAR(30) NOT NULL, FirstName NCHAR(29) NOT NULL, MiddleInitial NCHAR(1) NULL, SSN CHAR(11) NOT NULL, OtherColumns CHAR(258) NOT NULL DEFAULT 'Junk') GO ALTER TABLE Employee ADD CONSTRAINT EmployeePK PRIMARY KEY CLUSTERED (EmployeeID) GO It states on page 321 of the aforementione...

data import and word templates missing from CRM
Hi. I'm working with a new install of CRM and there are some icons missing in the setttings area such as the import function on the data management page and word templates under templates. Any ideas about why this is? Thanks. ...

novice needs info
I am trying to construct player cards for a baseball game...what i need to be able to do is to type constants like at bats, hits, etc. from one sheet and have them appear at different locations on the second sheet(the actual card)...some information such as average or era...needs to be affected by a formula before appearing on the second sheet....also need to know how to draw lines...vertical and horizontal in the second sheet...help..i am a dummy when it comes to this...thanks... -- mac53 Can you post a example of what sort of data in sheet 1 . Any thoughts on layout ?? -- VBA Noo...

Sales Order remains open after transfer to Invoice
Hi Everyone, Does somebody has a hint to solve this issue : Today a user tried to transfer a Sales Order from SOP windows into an Invoice. There was one item that was out of stock and therefore the system asked what to do ? user answered to backorder all the quantities of that item, since it was down to zero in inventory. Once the Invoice was created, the user realised that the Sales Order was still available in the open orders. She created the Backorder from the INvoice since the item was N/A (zero) and the BO created fine. A new SO was also generated from that BO... So far I've ...