?How to Display the same details under different groups

[Priv8joy]

Hello All.
I dont know if this is even possible. I am developing a report that contains the following formula I named @Group:

if {table.customer} in ["AT&T PT-PT", "VERIZON PT-PT", "UUNET INTERNET", "C&W ROUTER", "C&W INTERNET", "AT&T INTERNET"]
then "WAN CIRCUITS" else
if {table.customer} in ["C&W INTERNET", "AT&T INTERNET"] then "WAN VPN" else
{table.customer}

Well when I run the report, the Wan Circuits, shows up with data for the C&W Internet and the AT&T Internet, but nothing is displayed for WAN VPN.
Is it possible to display repeating grouped data.
Also, I am grouping by the @Group and my second grouping is by customer.
I have been working on this for two days and I am at my wits end. Thanks to all.

 

[synapsevampire]

You misunderstand groupings, think of them like sets.

A single entity does not exist within 2 different sets, so the first criteria will win.

The only way you can do this is by making another pass at the data, meaning a subreport.

The subreport record selection criteria would contain:

{table.customer} in "C&W INTERNET", "AT&T INTERNET"

And remove this criteria from the main report.

Place the subreport in the report footer, however you will not be able to summarize data for the main and subreports unless you use shared variables to pass values.

A way to work around this would be to approach data logically by using a formula akin to:

if {table.customer} in ["AT&T PT-PT", "VERIZON PT-PT", "UUNET INTERNET", "C&W ROUTER"]
then "WAN CIRCUITS" else
if {table.customer} in ["C&W INTERNET", "AT&T INTERNET"] then ""WAN CIRCUITS AND VPN" else
{table.customer}

-k