BusinessObjects Board

Display the report formats by selecting Prompt

building reports desktopintelligence
#1

Hi ,

I have a requirement in DeskI report.

If I select A prompt , display the tabular report.

If I select B prompt , display the pie chart.

If I select C prompt , display master detail report.

If I select D prompt , display the cross tab report.

What I have to do? Please help me out :roll_eyes:

Thanks in advance.

Arjun (BOB member since 2008-07-28)

how to display chart or table based on selecting data?
How to select the report display
#2

Kamalini,

First insert all these things in your report.. Then by using hiding option along with Userresponse, you can hide the remaining things which you do not want...

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

#3

Hi Jansi,

Thanks for quick reply and will try as you suggested . :slight_smile:

Arjun (BOB member since 2008-07-28)

#4

Hi

In my Understanding A, B, C, D are the input values for the prompt…? If so get the input values in userresponse function and make this as a variable. Use the Hide block option in table properties and hide the blocks as per your input Parameter using the variable created with userresponse.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

#5

Hi Jansi,Siva

Please give the step by step.

I have 4 types of report formats (tabular,crosstab,pie chart and master-

detail) in a single report.

Thanks for the help in advance :crazy_face:

Arjun (BOB member since 2008-07-28)

#6

Go through this . You would get some idea from this…

After that insert all the charts in your report and then follow the same steps given in the above link for each and every chart in your report. Come back with queries if you have any.

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

#7

Kamalini

Eventhough all the 4 types are sitting in the single report each table called as block, the formula which i have told you should apply to each block with the if then else condition.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

#8

hi kamalini,

did you get the result?
what happen for your report?

judia

judia (BOB member since 2008-06-24)

#9

Hi Judia,

Due to some other work I did not try on Friday :roll_eyes: .

I was confused at userresponse function about the dataprovider name…

For example, State, year and salesrevenue are the 3 objects in my report

Please help me :x .

Arjun (BOB member since 2008-07-28)

#10

If you are having only one data provider, then you can ignore the first parameter (i.e. data provider name). Or else you have to include that also…

If you do not want to type the data provider name, you can do it more exactly by Dataprovider()

Where are you facing problem?

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

#11

Thank you Jansi for your response.

I generated 3 reports(tabular, pie chart,cross tab) by using state,year and sales revenue.

Here is the problem of creating the variable.

Jansi,How can I select those for my requirement?

Arjun (BOB member since 2008-07-28)

#12

In your first post you mentioned something like if user select A, you want to display tabular report, … right?

What is the prompt text you are displaying for the user to select A,B,…?

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

#13

Jansi, those were not the Users but prompts.

select A ,select B,select C, select D will be the prompts

Arjun (BOB member since 2008-07-28)

#14

:?: How to show and hide reports based on user selection.
For Example : You have four reports TABULAR, PIE, DETAIL, CROSS TAB and user wants to see only one report in a single tab on its selection.

Solution:
:arrow: 1. Create a Prompt for the user input in universe.
:arrow: 2. Generate your report query and execute it.
:arrow: 3. Create different tables(blocks) in the report to display different reports. Here in your case you want to display 4 reports, so you want 4 table blocks.
:arrow: 4. Create one condition based on the User response for Table 1
:arrow: 5. Add the condition to the Table 1.
:arrow: 6. Repeat Steps 4 & 5 for other report Tables.

  1. If possible create a prompt for this report in universe like below:
=@prompt('Select your report',{'TABULAR','PIE','DETAIL','CROSS TAB'},,MONO,FREE)

  1. Generate your report in DeskI using the above prompt condition

  2. Now, Create your report with 4 different report tables. (As you say: Table 1 displays Tabular, Table 2 displays PIE, Table 3 displays DETAIL, Table 4 displays CROSS tab)

  3. Lets say user selects option ‘TABULAR’, For this you need a condition to show Table 1 and hide other tables. So lets create a condition to show Table 1 and hide others. The syntax would be:

=UserResponse("Data Provider Name", "Prompt Text") = "PIE"  or UserResponse("Data Provider Name", "Prompt Text") = "DETAIL" or UserResponse("Data Provider Name", "Prompt Text") = "CROSS TAB"
  1. To add the above condition on Table 1, Click Format Table → Appearnace → Hide Block → Click Edit Formula and the paste the above formula.

Like wise repeat the same for the other tables.

Hope that helps.

BO_Chief :us: (BOB member since 2004-06-06)

#15

hi kamalini,

did you follow the steps as said by bochief.

judia

judia (BOB member since 2008-06-24)

#16

Hi BO_Chief , Judia and all,

I have follow the steps and now it works correctly.

Due to some other work , I did not reply to you :slight_smile:

Thanks for the help :wave:

Arjun (BOB member since 2008-07-28)

#17

Hi, please enter your post as a new topic and we can merge it into the FAQ topic. I don’t want to remove it from this topic as it would leave a gap. Thanks.

Dave Rathbun :us: (BOB member since 2002-06-06)

#18

Dave,

I have created a new post. Its here.
https://bobj-board.org/t/114400

Thanks.

BO_Chief :us: (BOB member since 2004-06-06)

#19

OK, I’ve merged that topic into the FAQ: FAQ: Reporter

And I’ve closed the “report” in this topic.

Anita Craig :us: (BOB member since 2002-06-17)