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