By using this website, you agree to our Terms of Use (click here)
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.
I know this was a long time ago, but any update? I am attempting to group the T&M portion of (PM642000) by Task/Cost Code, but have not had any success. I can successfully create a (separate) (sub)report of the T&M lines and group by task/Cost Code. BUT this does NOT work when I add the subreport. Any ideas why this may be? Are there too many existing groupings in PM642000 to begin with?