table and chart

[system]

hi

IF we have two prompts like Start date and Ed date so if start and end date are same Table should be displayed and both dates are different Chart should be displayed? . Can we achieve this

Regards
kris

---

kris2727 (BOB member since 2010-07-28)

[system]

Hi,

Create both, table and chart in the report. Then conditionally hide one of them, either the table or the chart, depending on the values in the start date and end date prompts.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi Marek,

Thanks for your reply. i am a newbie in BO. I understood your logic,but not sure how to write condition to hide graph or chart.

Thanks
kris

---

kris2727 (BOB member since 2010-07-28)

[system]

hi use the below link it will help you.

FAQ: Reporter

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: 1. Create a Prompt for the user input in universe. 2. Generate your report query and execute it. 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…

---

upendra_boc (BOB member since 2010-09-06)

[system]

Simply putting it this way:
Create a variable “Selection Filter” as

 =if (Max([Start Date]) = Max([End Date])) then "Yes" else "No"

Create the Table and Graph as required.

Now, on the Table apply a filter using variable created and select value “Yes”
for the Graph apply the filter using the same variable but in this case select “No”.

This should work out for you.

---

nitin_gons (BOB member since 2009-05-26)