Report was even easier to do with the Insert Summary!
I now have a fabulous report of all live customer accounts, which can be searched using any combination of 6 dynamic parameters.
The tip about assigning a different value to any group containing a specific record (in this case Stop Flag = 3)...
Hi
Seems to have worked if I do a Section Expert Suppress in the Group Header, Details and Group Footer and put {#RTotal0}>0 by clicking on each of the X-2 formulae buttons.
Many thanks for your help.
Dee
Hi
Many thanks for the replies.
kenhamady, I went down the road of grouping before your reply came through so, so far so good!
In Group Header #1 I have my groups by invoice account:
Group #1 Name: customer.invoice_ac (string)
And in Details I now have @StopFlagStatus (Number) which is the...
Hi
I am trying to create a very simple report that details live customer accounts.
Each account has a stop_flag status: 0=Off Stop, 1=Soft Stop, 2=Hard Stop, 3=Closed
Some customer accounts are Delivery accounts only, so sales are invoiced on a related Invoicing (customer) account, not on the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.