Skip to Content
avatar image
Former Member

Hiding sections

Hi,

I have  a report in WebI. In that i have applied sections. Sometimes  the block underneath the sections doesn't have values. So i have hidden the blocks using the "Hide when Empty Property" in format table.

Now Similary the i want to hide the corresponding section also as there is no block related to it.For this similarly i used the "Hide when empty property" in format section. But no luck.

Also once i have checked the box for hide when empty in format section and next time when i come back to format section i find it unchecked.

So any solution to this or any other alternative to achive this.

thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Sep 10, 2013 at 10:04 AM

    Hi Ronny,

    I had the same problem myself and have found out how to resolve it.

    To hide a section where the data in the section is null you need to apply a filter on the data at the report level, not the section or table level if you had a table in your section.

    In Infoview (which is Webi in a web browser, usually displayed in HTML):

    1. Go into Edit mode

    2. In the left pane click on the 'Document Structure and Filters' button

    3. Add a new filter at the report level (not on the section or the table) to filter the null data out

    Your report should now only show you the sections that actually contain any data.

    Regards,

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I don't have a filter at the section/block level but i do have a filter at the page, level . Is that also a problem while hiding sections without data?

  • avatar image
    Former Member
    Sep 10, 2013 at 11:37 AM

    Hi Ronny,

    Do the following steps..

    1) Right Click on the  cell(section) and Go to Hide=> Select Hide When Formula.

    2)Enable the check box when the following formula is true

    3)inside the formula use the function isnull([obj name]) .

    obj name must be the object that you have used in the block(which makes the block empty/no value).

    (or)

    you can apply the filter on object with is not null option..( so that separate section will not occur)

    Regards

    Subbarao

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 07, 2012 at 11:17 AM

    Hi Ronny ,

    for this...

    once i have checked the box for hide when empty in format section and next time when i come back to format section i find it unchecked.

    can u try this  .

    1) first create a report and apply section

    2) right click on section select  format section enable " Hide when empty "

    3) go to the Document properties enable permanent regional formatting .

    4) check it.

     

       i hope this will helps to you.

    Regards

    DSP.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hey DSP

      Thanks for the reply,I tried it , but nothing happened, and in format section "hide when empty" is still again unchecked.

      thanks.

  • avatar image
    Former Member
    Aug 07, 2012 at 11:54 AM

    Hi Ronny

    http://www.forumtopics.com/busobj/viewtopic.php?p=699763

    please refer the above link. Hope it helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Carly Thomas

      Hi Carly,

      I tried opening the links which you have mentioned but they are not opening up.

      I am able to hide the block which is empty, i also want to hide the related section to it.Because when there is no vlaue related to that section don't want to show a empty section in the report.

      Thanks,

      Ronny.

  • avatar image
    Former Member
    Sep 10, 2013 at 10:15 AM

    Hi Ronny,

    If I am understanding your issue correctly:

    You want to hide a section which has a value in it but the block corresponding to it has no values.

    For eg. You have a section on Country(US,UK) and the block for US has data but for UK there is no dataa nd you want to hide the whole section for UK.

    If this is right..

    Then I would suggest to create a variable at report level. For eg. if the combination of all the objects lets say region,sum(revenue) for Country is NULL than 1 else 0. and apply the filter at report level for 1 instead of block or section level.

    Thanks

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 10, 2013 at 10:30 AM

    Hi ,

    Use " Hide When Empty" and also " Hide with formula true" and in that formula filteriut NULL values...This should help..

    Thanks

    Jagadish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2015 at 11:55 AM

    In 4.1, SP5, patch 1, you have the option, when you format your section, to hide section when the following are empty, then in the drop-down list, you can specify the block which holds your detail data.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2015 at 10:17 PM

    Simply right click on section -> choose hide when... & apply following formula:

    =IsNull(object)

    Thanks,

    SB

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 25, 2015 at 12:32 PM

    Hi Ronny

    Right Click on section -->Format Section-->Check ("Hide when following formula is true")

    Use this formula:

    =(Count([Key Figure])=0)

    [Key Figure] --> Any key figure you are using in table.

    Thanks

    Anurag

    Add comment
    10|10000 characters needed characters exceeded