CRM 4.0: How to use report wizard for duplicate product RRS feed

  • Question

  • I need a report which represent "Summary product by quote". As i created in report wizard  i can't grouping if the product duplicate. For example like this;

    Account Name :  XYZ
       - Quote ID : 001, Rev.0, Product A=1  Ea
       - Quote ID : 001, Rev.1  Product A =1 Ea, Product B=3 Ea

    The summary of report it should be represent as below;
    Account :XYZ
          -Product A =1  Ea(It not 2 Ea)
          -Product B= 3  Ea

    I'm not sure that this report can be create by report wizard or VB? Please help for the solution. Thanks in advance

    Thursday, June 7, 2012 4:25 AM