cancel
Showing results for 
Search instead for 
Did you mean: 

Hide Empty Columns in WWI Report

nmaral7
Explorer
0 Kudos
529

Dear Gurus,

We have a requirement in SAP WWI Report, to hide empty columns if not required.

e.g. I have a VAT1, has Char 1, Char 2 and Char 3

I have 3 instances,

this gives me Table with 3 columns and 3 rows for that VAT1

now Char 3 does not have any values in any instances for a given specification.

In that case I need to hide the column for char 3 from Report

Can you please suggest how it can be done.

We could do it using macro , but we dont know how macro works with WWI

Thanks in advance.

Accepted Solutions (0)

Answers (12)

Answers (12)

Ralph_P
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Niketan,

it might work when you insert a section break and switch to a two column layout. In the left column there is then a table for characteristic 1 and 2, in the right column a separate table for characteristic 3. But there will be an empty space between columns 2 and 3 then.

Best regards,

Ralph

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B

christoph_bergemann
Active Contributor
0 Kudos

Hello

from my point of view. you can not ! use a macro. This wil lnever work. You can achieve the topic only by using the many WWI options,

Your demand is very specific; and yes i am pretty sure there is a solution. But it will be a complex one.

The issue is: you do not know the number of instances; so your code must be "stable". It must work for 1 and more instances

By complex use of "IF/ELSE/ENDIF in combination with the "stack" options.. there might be a solution

I am not aware of a similar discussion here the last years.

C.B