Hiding Columns in Report

[Former Member]

Hi Experts,

Good Morning !

I have a requirement to hide columns which has no data. Example : In columns we have Jan to Dec but now we are in July Month so we have to display upto July and hide Aug to Sep columns dynamically. Is there any solution to do this in WAD/ Query Desiner 7.0.

Kindly provide me the inputs.

Thanks in Advance,

Suvarna

[former_member595061 · Accepted solution]

Dear Suvarna,

Please try the option 'zero suppression' in the Query Designer. Go the the properties of the query itself -> select tab 'Rows/Columns' -> choose the option 'suppress zeros': 'active (all values = 0)' -> 'effect on': 'columns'.

Afterwards in the executed template in java web choose settings -> data provider -> uncheck the option '"Key Figures" As Group: Apply Zero Suppression Only if All Elements Are 0'.

This works dynamically to suppress all columns which have no data.

Best regards,

Janine

[Former Member · Accepted solution]

Hi Janine,

Thanks a lot for your reply.

But can we do this in WAD.

settings -> data provider -> uncheck the option '"Key Figures" As Group: Apply Zero Suppression Only if All Elements Are 0'.

Thanks,

Suvarna

[Former Member · Accepted solution]

Thanks Janine..Problem is solved.

[Former Member · Accepted solution]

I could not find the Dataprovider option in WAD for BI 7.

Where do you get this option.

[Former Member · Accepted solution]

Hi Suresh,

Good Morning !

I couldnt find the option in WAD but in query designer there is an option.Goto to properties of structure and then goto Display tab and uncheck "Structure as group:Only apply supression when all elements are zero".

Hope this helps you.

Regards,

Suvarna

[Former Member · Accepted solution]

Hi Suvarna,

Thanks for the reply.

In the property of the structure we have "Structure as group:Only apply supression when all elements are zero".

But I am looking for "Apply Zero suppression to Structure Elements".

Is that only available in older version?

Regards,

Suresh

[Former Member]

Hi Suvarna,

U can do in this way!!!!

In u r query properties supresss with Zero --> and select the Colums radio button This will help u!!!

Thanks

Allu

[Former Member]

Dear Suvana,

how is the defineing of the rows and columns? I think you have no static structure in the columns.

I guess you have the time characteristic 0CALMONTH in your column tab defined. Now you can restrict with a value range selection BETWEEN. In the FROM parameter you can define 01.2009 and in the TO parameter you select from list and then in the SHOW dropdown box 'variable'. You find a standard SAP variable 0CMONTH with descrption current calendar month. It is a Exit variable. choose it. Now you get automatically and dynamically only values up to the current month. also you have to mark in the properties advanced tab ONLY VALUES IN INFOPROVIDER. If you have zero values in the infoprovider you go to the properties of the query tab rows/columns and mark in the sub tab effect on the entry columns.

Now it must work or I need the exact definition of your query.

take care

Leo

[garry_a]

Hi

Try out with cell defination if the month column value is zeor. then do not show.

regards,

Amol

[Former Member]

Hi Suvarna,

I guess you can create a restricted key figure where you select the key figure and restrict it by current month. This way no data would be available for later months. I am not sure if SAP calculates the current month automatically. If not possible you can calculate the current month using a variable in user exit and restrict based on the variable.

Bye

Dinesh

[Former Member]

Hi Dinesh,

You are correct. But in Layout also I want to hide the other months. Now in Layout we are displaying Jan to Dec and we have data upto July . From Aug to Dec it is blank.

User requirement is to hide the months which have no data.

Thanks,

Suvarna

[Former Member]

Hi,

Not sure you can do that programtically. Would check and come back if I find any option.

Bye

Dinesh

[Former Member]

Hi Vandana,

Check if "Values in the infoprovider" is checked in the properties of the characteristic for "ACCESS TYPE FOR RESULT VALUES" and "FILTER SELECTION DURING QUERY EXECUTION"

Hope it helps.

Thanks & Regards,

Bhargava Bommidi.

[Former Member]

Hi Bhargava,

Thanks for your reply but no luck.I want to Hide the Columns dynamically which have no data.

Thanks,

Suvarna