Skip to Content
author's profile photo Former Member
Former Member

Hiding Columns in Report

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Aug 02, 2009 at 12:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2009 at 05:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2009 at 11:20 AM

    Hi

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

    regards,

    Amol

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2009 at 12:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2009 at 05:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.