Adding a group that only applies to another existing group
I have (2) existing groups in a Pro Forma invoice report. One for T&M lines and one for Progress Bill lines. I want to group my T&M lines by Account Group, but when I add a Group for Account Group, the Progress Bill lines do not print on my report. Is there a way to group to content of only one of the existing groups?
I believe this is because I am using the Schema builder Relationship between the PM ProformaLine table and the PMTran table to get the transaction Account Group ID Description. However, the Progress Bill Proforma line does not have a PMTran transaction.
Try using the IsNull formula in your group formula so it can have a value (any value) to group on even when Account Group is null.