I have a custom report that is presenting multiple lines per record. I need to group the data on the Invoice number. Is that possible in GP RW? if so, how?
I have a custom report that is presenting multiple lines per record. I need to group the data on the Invoice number. Is that possible in GP RW? if so, how?
Create an additional footer, based on invoice number. Add the fields you want to see and change data types to count, sum, average etc. as desired.
To hide the body, without removing it. Create a calculated field (string or number) and return an empty constant ("" or 0). Then suppress the section based on the calculated field.
Regards
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156