BusinessObjects Board

How to select the report display

building reports webintelligence
#1

Hi,

We have one requirement, for example we have one report in webi(xir2),
When user running the report, one prompt should ask to choose report types

Select the report format

  1. Table
  2. Chart.

When users selecting the chart, the report only show the chart

We don’t have any idea on this, some one give me some suggestions

Thanks
M.Siva…

kongusiva :india: (BOB member since 2006-08-09)

how to hide tables based on certain condition
display no data message
how to dispaly the alert messages
Hide a Table
Hide a Table
Dynamically alter report structure
#2

Kongusiva, you can do it this way.

  1. Create the table in 1 block. deselect the show if empty filter. Create a report level filter for userresponse of your table/chart prompt equal to table.
  2. Create the chart in another block. Deselect the show if empty filter. Create a report level filter for userresponse of your table/chart prompt equal to chart.

Roshknee :india: (BOB member since 2007-10-29)

#3

Roshknee,
Thanks for your quick response…

i am not clear your answer… can you give me some detail …
Thanks,
M.Siva…

kongusiva :india: (BOB member since 2006-08-09)

#4

Ok here goes :slight_smile: Edit the report and do these steps:-

  1. You will have a prompt which asks for the Chart / Table option. Now this is a dummy prompt as it doesnt modify the sql query in any way, so you could code something like this :-
    TABLE.COL != @Prompt(‘Choose View Mode:’,‘A’,{‘Chart’,‘Table’},MONO,CONSTRAINED,{‘Table’},Not_persistent,USER:0)
    (this will always be true- so will not affect results of your query)

  2. Use the variable editor to create a variable which captures the user response of the prompt for Choose View Mode.

  3. Create the table by dragging your fields.

  4. Use the filter pane - theres an icon on the menu to show/hide the filter pane. Select the table. Drag the user resonse variable and create the filter for userresponse= “Table” for the table. This means the table will be shown only if the value for the prompt is Table.

  5. Run the report by selecting Chart as your prompt value. Now you will get a blank report as the filter condition is not satisfied.

  6. Now create the chart. Create a filter for userresponse for the prompt being Chart and apply it to the chart block. Now it will be shown only if the prompt value is Chart.

So there it is, based on filters only 1 of the two will be shown at a time. Hope this makes sense. We have actually implemented this in my project though not with a table and a chart, but 2 different tables.

Roshknee :india: (BOB member since 2007-10-29)

#5

I forgot to mention that the Show If Empty property for the chart and table should be unchecked- thats how it disappears whenever the filter condition is not satisified.

Roshknee :india: (BOB member since 2007-10-29)

#6

Thank you, Roshknee, it’s really a good hint…

Ale.

Bo_Arale :it: (BOB member since 2007-09-10)

#7

Nice post

Swimmer :netherlands: (BOB member since 2006-08-23)

#8

I don’t see a show if empty in DESKI - what is the equivalent?

ldcaudle (BOB member since 2005-10-04)

#9

Equivalent in Desk-I is pretty simple. Go through this topic

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