cancel
Showing results for 
Search instead for 
Did you mean: 

Hiding Columns in Report

Former Member
0 Kudos
959

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member595061
Contributor

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
0 Kudos

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
0 Kudos

Thanks Janine..Problem is solved.

Former Member
0 Kudos

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

Where do you get this option.

Former Member
0 Kudos

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
0 Kudos

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

Answers (4)

Answers (4)

Former Member
0 Kudos

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
0 Kudos

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
Active Participant
0 Kudos

Hi

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

regards,

Amol

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Hi,

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

Bye

Dinesh

Former Member
0 Kudos

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
0 Kudos

Hi Bhargava,

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

Thanks,

Suvarna