We use Parent : Child relationship and we create invoices for both Parent and Child. I am trying to customize the Sales By Customer report but am running into trouble with the way data is displayed when group by Parent – only Name/ID and Sales Total display. To see the other columns I have in the report I have to expand the group. Why does it do this???
CUSTOMER
PARENT CUSTOMER/JOB: COMPANY NAME
CUSTOMER TYPE
CUSTOMER CATEGORY: NAME
SALES
VMR033
$2,689.15
Total
$2,689.15
All I need to do is display the Parent, two other custom fields, and the Sales Total. Problem is when results are grouped can’t see the other columns on the report.
This is a cached copy. Click here to see the original post.