Joined: 17 Feb 2016
Online Status: Offline
Posts: 8
Topic: Conditional Grouping Posted: 16 Mar 2017 at 6:50am
Hi
I have a financial report which is grouped by Sales Year, then by Sales Period. In each period Invoices and Credits are displayed in numerical order irrespective of whether each begins with INV for invoice or CRE for Credit Note. Within the Sales Year Group and then the Sales Period Group, I would like to separate the invoices into one group and the credit notes into another (so that I can display and total each type separately). Any help would be much appreciated.
Many thanks
Dee
Joined: 17 Feb 2016
Online Status: Offline
Posts: 8
Posted: 16 Mar 2017 at 7:02am
Oh, I think I've just cracked it!
Insert / Group / Common Tab: Records will be sorted & grouped by: {table.invoice}/ In specified order / Named Group: Invoices / New / table.invoice / startswith / INV / Add / OK
and then do the same for Credit notes CRE.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged