Skip to main content

Notifications

Microsoft Dynamics RMS forum

X-Report

Posted on by Microsoft Employee

I would like to generate the X-Report which can do following:

Group certain number of departments and provide you sales total for that group

How would I achieve this? If there is any custom X-reports available at customer source, please provide me a link to it. Any help would be appreciated.

Thanks,

pappu

*This post is locked for comments

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: X-Report

    Is this what you are looking for?

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

    Begin ReportSummary

      ReportType = reporttypeSales

      ReportTitle = "Department Sales Report"

      PageOrientation = pageorientationLandscape

      OutLineMode = True

      Groups = 1

      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

    INNER JOIN  Batch WITH(NOLOCK)

                     ON [Transaction].BatchNumber = Batch.BatchNumber AND [Transaction].StoreID = Batch.StoreID

         LEFT JOIN   Item  WITH(NOLOCK) ON TransactionEntry.ItemID = Item.ID

         LEFT JOIN   Department WITH(NOLOCK) ON Item.DepartmentID = Department.ID

         LEFT JOIN   Category WITH(NOLOCK) ON Item.CategoryID = Category.ID

         LEFT JOIN   Store WITH(NOLOCK) ON TransactionEntry.StoreID = Store.ID

    <END>

      SelCriteria = ""

      GroupBy = ""

      SortOrder = ""

    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 = "<MonthStart>"

      FilterHilim = "<Today>"

    End Filter

    //--- Columns ---//

    Begin Column

      FieldName = "Department.Name"

      DrillDownFieldName = "Department.Name"

      DrillDownReportName = ""

      Title = "Department"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2505

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Category.Name"

      DrillDownFieldName = "Category.Name"

      DrillDownReportName = ""

      Title = "Category"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2300

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SubDescription1"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Subcategory"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1095

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.Name"

      DrillDownFieldName = "Store.Name"

      DrillDownReportName = ""

      Title = "Store"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2085

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.ID"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store ID"

      VBDataType = vbLong

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

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

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

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

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

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

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

      FilterDisabled = False

      ColWidth = 1560

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "[Transaction].Time"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Date"

      VBDataType = vbDate

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1335

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Sales"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Sales"

      VBDataType = vbCurrency

      Formula = "TransactionEntry.Price * TransactionEntry.Quantity"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1800

      GroupMethod = groupmethodSum

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Cost"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Cost"

      VBDataType = vbCurrency

      Formula = "TransactionEntry.Cost * TransactionEntry.Quantity"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1800

      GroupMethod = groupmethodSum

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Profit"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Profit"

      VBDataType = vbCurrency

      Formula = "(TransactionEntry.Price * TransactionEntry.Quantity) - (TransactionEntry.Cost * TransactionEntry.Quantity)"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1800

      GroupMethod = groupmethodSum

      ColFormat = ""

    End Column

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans