Matrix Sales

Yes as part of our Matrix Bundle add-on.

Hi there,

Retail Analytics for Microsoft RMS is designed to help retailers manage their business by delivering analytical reporting on business performance. Easily identify trends, buying patterns, seasonality, and other key performance indicators for your business. If you enter it in RMS (matrix) you can report on it in Retail Analytics. We also provide free demonstrations of the product on your data at no cost. If you have any questions or if there is anything that we can do for you, please let me know.

Thanks,

Jen Losch snipped-for-privacy@profad.com

"Lum> Please do provide more information.

find it bellow

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

Begin ReportSummary ReportType = reporttypeSales ReportTitle = "Top Discription Report" PageOrientation = pageorientationPortrait OutLineMode = True Groups = 0 GroupDescription = "" DisplayLogo = True LogoFileName = "MyLogo.bmp" ProcedureCall = "" TablesQueried FROM TransactionEntry WITH(NOLOCK) INNER JOIN [Transaction] WITH(NOLOCK) ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID LEFT JOIN Item WITH (NOLOCK) ON TransactionEntry.ItemID = Item.ID LEFT JOIN Store ON TransactionEntry.StoreID = Store.ID

SelCriteria = "" GroupBy = "Item.Description " SortOrder = "Sales DESC" End ReportSummary

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

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 16 Color = "Blue" End TitleRow

Begin TitleRow Text = "" Font = "Arial" FontBold = True FontSize = 12 Color = "Black" End TitleRow

Begin TitleRow Text = "Generated On " Font = "Arial" FontBold = True FontSize = 10 Color = "Black" End TitleRow

//--- Filters ---//

Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter

//--- Columns ---//

Begin Column FieldName = "Item.Description" DrillDownFieldName = "Item.Description" DrillDownReportName = "" Title = "Description" VBDataType = vbString Formula = "MAX(Item.Description)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 3100 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.ID" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store ID" VBDataType = vbLong Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 870 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.StoreCode" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store Code" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1095 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.Region" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store Region" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1335 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.City" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store City" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1020 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.State" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store State" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1155 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.Zip" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store Zip" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 945 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "Store.Country" DrillDownFieldName = "" DrillDownReportName = "" Title = "Store Country" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1560 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "[Transaction].Time" DrillDownFieldName = "" DrillDownReportName = "" Title = "Date Sold" VBDataType = vbDate Formula = "" ColHidden = True ColNotDisplayable = True FilterDisabled = False ColWidth = 1035 GroupMethod = groupmethodNone ColFormat = "" End Column

Begin Column FieldName = "QtySold" DrillDownFieldName = "" DrillDownReportName = "" Title = "Qty Sold" VBDataType = vbDouble Formula = "SUM(TransactionEntry.Quantity)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1710 GroupMethod = groupmethodSum ColFormat = "#.##" End Column

Begin Column FieldName = "Sales" DrillDownFieldName = "" DrillDownReportName = "" Title = "Sales" VBDataType = vbCurrency Formula = "SUM(TransactionEntry.Price * TransactionEntry.Quantity)" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1830 GroupMethod = groupmethodSum ColFormat = "" End Column

------------------------------------- really i appreciate your effort on this graet website