We are running Max Ent 9.5 SQL. I would appreciate someones assistance, guidance.
As an example I am extractng AMGR_Opportunity_Tbl field information from Max using Crystal.
The field data includes :-
Name
Actual Revenue
UDF Product (User Defined Field that may have Multiple Entries)
Status (3 for Won)
In the case of a sale with a single UDF Product the report works fine.
As an example
Name Actual Revenue UDF Product Status
**** ************** *********** ******
XYZ $50,000 ABC 3
Total $50,000
But when there is a sale with multiple products selected under UDF Product then the reports displays the revenue for each UDF Product.
As an example
Name Actual Revenue UDF Product Status
**** ************** *********** ******
XYZ $50,000 ABC 3
XYZ $50,000 DEF 3
Total $100,000
This is incorrect as the sale value, i.e. Actual Revenue is on $50,000 not $100,000.
Ideally, what I would like to display is
Name Actual Revenue UDF Product Status
**** ************** *********** ******
XYZ $50,000 ABC, DEF 3
Total $50,000
or even
Name Actual Revenue UDF Product Status
**** ************** *********** ******
XYZ $50,000 ABC 3
XYX DEF 3
Total $50,000
I have been able to display this version OK by Supressing the Actual Revenue if duplicated however the total is incorrect i.e. $100,000
Could it be something to do with the LINK I have setup for the UDF or something else.
Any suggestions most welcome, as I don't have much hair left to pull out.
Regards
bwilliams
Original Post