locked
A mail merge template that should group the Quote products based on ‘Product Type’ (field in Product record - ProductTypeCode) RRS feed

  • Question

  • Hi Experts,

    Please let me know how can we achieve this.

    Requirement – A mail merge template that should group the Quote products based on ‘Product Type’ (field in Product record - ProductTypeCode)

    Example:  Consider a Quote with name:  CRM Quote

    Two Quote Products associated to it  -

    Quote Product 1:

    Name : CRM 2011

    Product Type : Year2011

    Quote Product 2 :

    Name : CRM 2013

    Product Type : Year2013

    Result:

    We want the mail merge document look like below.

    Year2011

    CRM 2011

    $1000

    Year2013

    CRM 2013

    $3000

    Note:  Year2011, Year2013 are group name and CRM 2011, CRM 2013 are product name

    Thanks,

    Palani

    Tuesday, February 4, 2014 9:16 AM

All replies

  • Hi,

         As you want to display rollup figures, it would be best to do this in a simple SSRS / Report wizard report. Mail merge template is not the best way to achieve this.


    Hope this helps.
     
    -----------------------------------------------------------------------
     Minal Dahiya
    blog : http://minaldahiya.blogspot.com.au/

     
    If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"

    • Proposed as answer by Minal Dahiya Tuesday, February 4, 2014 10:26 AM
    Tuesday, February 4, 2014 10:26 AM