BusinessObjects Board

Hiding the Block and title cell

building reports desktopintelligence
#1

Hi all,

I have two cells and one block in my report.

  1. 1 st cell is for report title.

  2. 2 nd cell is for label “There is no data” based on a flag.

  3. Report block.

In the universe, there is one flag object values are Y or N).

I) If the object value is ‘Y’ which we select in the query panel(Condition List), then Report title(1 st cell ) and Report block(3 rd) should be displayed, at the same time the 2 nd should not be displayed based on formula.

II) If it is ‘N’ means, the 2 nd cell should be displayed and the remaining( 1 st cell & report block) should not displayed based on formula.

Please advise and send ur valuable views.

Cheers,
Muthu.

Muthulksu :india: (BOB member since 2008-07-11)

hiding the tables with prompts?
Need DESKI instructions to hide table and section
How to use userresponce function in if then else condition?
hiding the report table by using condition?
#2

You will have to use if statement to blank out the cell when the flag changes (Y or N)

 =IF <FLAG>= "Y" THEN "REPORT TITLE" ELSE ""

.

haider :es: (BOB member since 2005-07-18)

#3

Thanks Haider, but it is not working.
Please read my above mail again and give me some valuable ideas.

Muthulksu :india: (BOB member since 2008-07-11)

#4

Looks like my reply was not valuable(kidding)

Have you tried the suggested steps?
What was the problem and any errors.

Give details when you do anything with the steps followed

.

haider :es: (BOB member since 2005-07-18)

#5

hi haider

good afternoon.
i tried and i made the title cell to vanish when =‘n’
and the label cell appeared for =‘n’

but my question is how could i hide the whole report block.
i write a condition in the hide block edit tab

=if =‘n’ then " "
but it didn’t work…

thank you

judia

judia (BOB member since 2008-06-24)

#6

You dont have to use any if condition, just put the expression directly as

 =<FLAG>= 'Y'

And put a tick on hide block check box

.

haider :es: (BOB member since 2005-07-18)

#7

haider,

i wrote the same condition , still i could not hide the block…

judia

judia (BOB member since 2008-06-24)

#8

For me also, please advise me.

Muthulksu :india: (BOB member since 2008-07-11)

#9

Haider,

Hi… If we check the Hide the block option, the block will be hidden always no matter whether Flag has Y or N. Am I right?

Jansi :india: (BOB member since 2008-05-12)

#10

hi haider,

it worked for me, when i created an condition based on user response object.
thank you haider…

judia

judia (BOB member since 2008-06-24)

#11

Hi Judia,

Can u send me the condition which u created(User response object)

Cheers,
Muthu.

Muthulksu :india: (BOB member since 2008-07-11)

#12

This

=UserResponse ("Query 1" , "ENTER value") = "Y"

Jansi,
It will always hide the block if there is no formula used,
When an expression is used then it gets hidden based on the criteria

.

haider :es: (BOB member since 2005-07-18)

#13

Yes Haider. It is working. Actually the problem was, I did not know where to write this condition and now I got it. :slight_smile:

Thanks to Judia. Because of your words below I understood where to write the condition.

Jansi :india: (BOB member since 2008-05-12)

#14

hi Jansi, Hyder

Where i have to use that UserResponse() formula? whether in the cell i want to hide or somewhere else?

Muthulksu :india: (BOB member since 2008-07-11)

#15

You should write that formula here. I shall tell steps. Follow them

  1. click the block you want to hide
    2)Go to Format -> Table
    3)Click Appearance tab
    4)You can see a check box, Hide Block. Are you seeing?
    5)Check that check box
    6)You can see a button Edit below that along with a blank text box.
    7)Click that Edit, a box opens.
    There type this code.

In this way you can achieve what you need.

Jansi :india: (BOB member since 2008-05-12)

#16

Hi Jansi,

I have two cells and one block in my report.

  1. 1 st cell is for report title.

  2. 2 nd cell is for label “There is no data” based on a flag.

  3. Report block.

In the universe, there is one flag object values are Y or N).

I) If the object value is ‘Y’ which we select in the query panel(Condition List), then Report title(1 st cell ) and Report block(3 rd) should be displayed, at the same time the 2 nd should not be displayed based on formula.

As per the above statement, i want to block the 2 nd cell. consider that my flag value is always ‘Y’

Muthulksu :india: (BOB member since 2008-07-11)

#17

hi,

did you get the result? just try to follow the steps given by jansi in the above post.

judia

judia (BOB member since 2008-06-24)

#18

Also if you want to hide a single cell based on the flag, you can create an alerter for that cell and in that condition you can give your condition and in the result you can choose what you want to display.

Also for a single cell, we can achieve the same by right clicking it ->format cell -> appearance and do the same as you did for hiding a block

Jansi :india: (BOB member since 2008-05-12)