Matrix Sales

Anyone have a DETAILED SALES BY MATRIX report?
0
Luminox (155)
4/19/2007 5:32:02 PM
pos 14173 articles. 0 followers. Follow

5 Replies
1508 Views

Similar Articles

[PageSpeed] 49

Yes as part of our Matrix Bundle add-on.

Afshin Alikhani - [ afshin@retailrealm.co.uk ]
CEO - Retail Realm
= = = = = = = = = =
"Luminox" <Luminox@discussions.microsoft.com> wrote in message 
news:7B67EB1D-AA38-4FAD-8683-5B3E9FFFE742@microsoft.com...
> Anyone have a DETAILED SALES BY MATRIX report? 


0
afshin (783)
4/19/2007 7:05:53 PM
Please do provide more information.

"Afshin Alikhani" wrote:

> Yes as part of our Matrix Bundle add-on.
> 
> Afshin Alikhani - [ afshin@retailrealm.co.uk ]
> CEO - Retail Realm
> = = = = = = = = = =
> "Luminox" <Luminox@discussions.microsoft.com> wrote in message 
> news:7B67EB1D-AA38-4FAD-8683-5B3E9FFFE742@microsoft.com...
> > Anyone have a DETAILED SALES BY MATRIX report? 
> 
> 
> 
0
Luminox (155)
4/19/2007 7:18:01 PM
Please do provide more information.

"Afshin Alikhani" wrote:

> Yes as part of our Matrix Bundle add-on.
> 
> Afshin Alikhani - [ afshin@retailrealm.co.uk ]
> CEO - Retail Realm
> = = = = = = = = = =
> "Luminox" <Luminox@discussions.microsoft.com> wrote in message 
> news:7B67EB1D-AA38-4FAD-8683-5B3E9FFFE742@microsoft.com...
> > Anyone have a DETAILED SALES BY MATRIX report? 
> 
> 
> 
0
Luminox (155)
4/19/2007 7:20:02 PM
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
jenl@profad.com
701 235 2363 ext 248

"Luminox" wrote:

> Please do provide more information.
> 
> "Afshin Alikhani" wrote:
> 
> > Yes as part of our Matrix Bundle add-on.
> > 
> > Afshin Alikhani - [ afshin@retailrealm.co.uk ]
> > CEO - Retail Realm
> > = = = = = = = = = =
> > "Luminox" <Luminox@discussions.microsoft.com> wrote in message 
> > news:7B67EB1D-AA38-4FAD-8683-5B3E9FFFE742@microsoft.com...
> > > Anyone have a DETAILED SALES BY MATRIX report? 
> > 
> > 
> > 
0
JenLosch (82)
4/25/2007 4:36:03 PM
responding to
http://www.beansmart.com/point-of-sale/Matrix-Sales-23117-.htm 
a.dardiry wrote:

=?Utf-8?B?THVtaW5veA==?= wrote:


> Anyone have a DETAILED SALES BY MATRIX report?

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 = <BEGIN>
   
      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

<END>

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


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

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

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

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


//--- Filters ---//

Begin Filter
   FieldName = "[Transaction].Time"
   FilterOp = reportfilteropBetween
   FilterLoLim = "<YearStart>"
   FilterHilim = "<Today>"
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




0
7/13/2011 1:25:40 PM
Reply:

Similar Artilces: