BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Supress Section If report field value is null


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
Kanchan
Senior Member
Senior Member



Joined: 03 Jan 2010

Posts: 37



PostPosted: Thu Jul 26, 2012 11:52 pm 
Post subject: Supress Section If report field value is null

Hi ,

I am using BO XI 3.x version.
I have a requirement to create a webi report which has grouping based on 3 entities e.g-
Company -> Hierarchy -> Account
in order to get this I have created 1st section on Company then inside this 2nd section for Hierarchy and my last section is on Account , Now here my hierarchy data is optional it's not always associated to the company so i want to suppress my 2nd section whenever hierarchy is null in the database.
For that when i set 'show when empty' option in Hierarchy section properties it removes Account sections as well because it resides inside the Hierarchy section.
Can anyone suggest me how can i achive to supress the Hierarchy section when it is nulll.

Thanks in Advance!
Kanchan
Back to top
cyberdude
Principal Member
Principal Member



Joined: 05 Feb 2007

Posts: 274
Location: hmm....the place I like the most... In my cube..


flag
PostPosted: Mon Jul 30, 2012 10:34 am 
Post subject: Re: Supress Section If report field value is null

Kanchan,

Are you selecting the proper section and unchecking the check box for show when empty. I cannot replicate this option as we are on BI 4.0 But it should work. You need to select the appropriate section. Try to work this in structure mode
Back to top
erik.stenson
Forum Enthusiast
Forum Enthusiast



Joined: 30 Jul 2012

Posts: 1303


flag
PostPosted: Mon Jul 30, 2012 12:54 pm 
Post subject: Re: Supress Section If report field value is null

You could add a filter to the section. First click on the section, then go to the filter pane. Make sure that it is showing the filters for the section. Then add the object that you are requiring not be null.
Back to top
Kanchan
Senior Member
Senior Member



Joined: 03 Jan 2010

Posts: 37



PostPosted: Tue Jul 31, 2012 11:27 pm 
Post subject: Re: Supress Section If report field value is null

Thanks for the reply!!

The Hierarchy section is getting suppressed but with that account section is also going away because that is inside the hierarchy section , what i want that because hierarchy is optional only hierarchy section should be suppressed but account details should be shown up on the report.


Thanks
Kanchan
Back to top
cyberdude
Principal Member
Principal Member



Joined: 05 Feb 2007

Posts: 274
Location: hmm....the place I like the most... In my cube..


flag
PostPosted: Wed Aug 01, 2012 7:43 am 
Post subject: Re: Supress Section If report field value is null

As far as I know we cannot suppress the Hierarchy Section which is containing Account Section with out supressing Account Section.
Back to top
Kanchan
Senior Member
Senior Member



Joined: 03 Jan 2010

Posts: 37



PostPosted: Sun Aug 05, 2012 12:00 pm 
Post subject: Re: Supress Section If report field value is null

Thanks!

Can i achieve the same layout in other way i.e. without putting sections in the report?Is there any other solution?


Thanks
Kanchan
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.3998 seconds using 17 queries. (SQL 0.3726 Parse 0.0011 Other 0.0261)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo