Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Report Visa Transactions

Posted on by Microsoft Employee

hello

i need Report 

Performance of visa sales, number of transactions & value, per store.

I use version 2.0.2012

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Visa Transactions

    Try this.    Save this as a custom report under the HQ\Reports folder.  

    This was mostly copied from the store Tender Summary report but changed for HQ and by store.  

    You will need to add Number of Transactions & Value.

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

    Begin ReportSummary

      ReportType = reporttypeSales

      ReportTitle = "Tender Summary"

      PageOrientation = pageorientationPortrait

      WordWrap = True

      OutLineMode = True

      Groups = 2

      GroupDescription = ""

      DisplayLogo = True

      LogoFileName = "MyLogo.bmp"

      ProcedureCall = ""

      TablesQueried = "FROM TenderEntry LEFT JOIN [Transaction] ON TenderEntry.TransactionNumber = [Transaction].TransactionNumber LEFT JOIN Batch ON [Transaction].BatchNumber = Batch.BatchNumber LEFT JOIN [Store] ON Store.ID = TenderEntry.StoreID  LEFT JOIN Tender ON TenderEntry.TenderID = Tender.ID "

      SelCriteria = ""

      GroupBy = ""

      SortOrder = "Store.Name, TenderEntry.Description, TenderEntry.Amount, [Transaction].Time"

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

      FilterHilim = "<Today>"

    End Filter

    Begin Filter

      FieldName = "Tender.inactive"

      FilterOp = reportfilteropEqual

      FilterLoLim = "0"

      FilterHilim = "0"

    End Filter

    //--- Columns ---//

    Begin Column

      FieldName = "Store.Name"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store Name"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1500

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "TenderEntry.Description"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Tender"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "[Transaction].Time"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Date"

      VBDataType = vbdate

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1500

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "Tenderentry.Amount"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Amount"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodSum

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "Tenderentry.Amount"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Max Amount"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodMax

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "Tenderentry.Amount"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Min Amount"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodMin

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "Tenderentry.Amount"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Avg Amount"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodAverage

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    End Column

    Begin Column

      FieldName = "Tender.inactive"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Tender Inactive"

      VBDataType = vbBoolean

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1500

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Tenderentry.StoreID"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store ID"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1500

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftTop

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans