The Indispensable Karen!
That works with or without the involvement of Regions:
Great trick, THANK you. Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com
------ Original Message ------
From "'Karen Tellef' via RBASE-L" <rbase-l@googlegroups.com>
To "rbase-l@googlegroups.com" <rbase-l@googlegroups.com>
Date 8/2/2023 12:18:47 PM
Subject Re: [RBASE-L] - Report Header Bands | Failure to collapse for
NULL data
Try replacing your DBText fields with DBMemos and mark each memo
"stretch". I have notes that at one time I had to do that to suppress
the blank space
Karen
On Wednesday, August 2, 2023 at 02:11:35 PM CDT, Bruce Chitiea
<rby...@safesectors.com> wrote:
All:
While generating a five-digit Chart of Accounts report, several Break
Header bands (defined on data values 'glCode1 ... glCode5') fail to
"collapse" when header data values are NULL:
Dynamically-sized Break Header bands H0, H1 and H2 contain only DBText
fields, aligning vertically as desired.
Dynamically-sized Break Header bands H3 and H4 contain Regions where we
want NULL-valued records to collapse.
The H3 band contains the Before Generate EEP
IF vglCode4 IS NULL THEN
PROPERTY cid_region_h3 VISIBLE 'FALSE'
ELSE
PROPERTY cid_region_h3 VISIBLE 'TRUE'
ENDIF
RETURN
The H4 band contains the Before Generate EEP
IF vglCode5 IS NULL THEN
PROPERTY cid_region_h4 VISIBLE 'FALSE'
ELSE
PROPERTY cid_region_h4 VISIBLE 'TRUE'
ENDIF
RETURN
... based on Report variables:
Report: household_chartOfAccounts_level_5
1 : TEXT : H3 : vglCode4 = (glCode4)
2 : TEXT : H4 : vglCode5 = (glCode5)
I find no reference to anything approximating a Region or Band
"collapse" PROPERTY.
I've monkeyed around with various Shift and Stretch properties, to no
effect.
Any thoughts / pointers MUCH appreciated!
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em162e450d-6d8d-47e8-90b9-b45d62015b03%40fd7d3b70.com
<https://groups.google.com/d/msgid/rbase-l/em162e450d-6d8d-47e8-90b9-b45d62015b03%40fd7d3b70.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1097136547.988820.1691003927776%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/1097136547.988820.1691003927776%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emecd03f4a-6584-42c9-bdae-f8868202dc6d%40fd7d3b70.com.