Combing Two Groups into One to Avoid an Empty TOC Level

mwilliams
edited February 11, 2022 in Analytics #1
This example shows a way to use multiple fields in a group expression to avoid using multiple groups. This example is a solution to a problem where a forum poster wanted to be able to hide an outer grouping in the TOC, while showing the groupings underneath it.<br />
<br />
In the example, the second grouping in the table combines two fields, but the TOC expression is set to only show the second field. Without this method, the normal solution of simply removing the TOC expression leaves a blank bookmark, rather than not creating it. If there wasn't a grouping under it, the no expression solution would work as expected. Some simple scripting and a visibility expression is also used to only show the midde "grouping" at the correct time. This report was created in BIRT 3.7.2.<br />
<br />
This report is explained further in this blog post.
Warning No formatter is installed for the format ipb