SMTP is displayed in the email ID field on Print Purchase Order report in Track-It! 2019

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It! 2019 R3


    APPLIES TO:

    Track-It! 2019 R3



    PROBLEM:

     

    SMTP is displayed in the email ID field on Print Purchase Order report in Track-It! 2019

    There are total 3 Out-Of-the-Box reports having email fields. 
    1.Ticket Print Report 
    2.Asset Print Report 
    3.Purchase Order Print Report 

    When trying to print these reports, the email ID is displayed with a SMTP tag.  
    User-added image
      

     


    CAUSE:

    This is a defect in Track-It!.


    SOLUTION:

    Solution:
    The 3 Out-Of-the-Box reports must be copied and modified using the below instructions.
    1. Edit the copied report in the Report designer.
    2. Create Calculated field from the Field List
    User-added image

    Add Name- no space allowed
    Display Name as 'AlternateEmail'
    Data Source- on adding data source the field gets added as child of given data source
    Expression.(See next point)
    User-added image
    3. Expression: Choose substring expression
    Example: let the field be = Alternate Email ID, The Expression becomes : Substring( [Alternate Email ID] ,CharIndex('}', [Alternate Email ID] )+1 )  
    User-added image
    4. Use this calculated field in your report.
     


    Article Number:

    000173194


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles