Example Country Name is like India/UK or ALL
In parameter I selected India or UK it should show only
perticular country details in BO.If i select ALL in
parameter.It should show both country data in different
tables.
Answers were Sorted based on User's Feedback
Answer / kiruba
create two tables.
one is for 'India/UK'. depend on your selection in the
prompt the first table should show the result. if you
select India the table should show the India result. If you
select UK then the table should show the UK result. that
time hide the second table.
when you select 'ALL' in the prompt, then show both the
tables. use the filter condition 'Country_name = India' in
the first table. us the filter 'Country_name = UK' in the
second table.
But you have to show the results in both the table
when 'Prompt = ALL'.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kishoe
u can use the combined query to the "ALL" Objects use
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anil kumar ganga
use cascading prompts. If you select India then it wil
bring only corresponding state details.
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / narendra
using custom SQL we can achieve this. Country. country
name=@prompt('enetr ur country','A','Classname/object name',
)or ALL=@prompt('enetr ur country','A','Classname/object
name', )
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / varun sharma
use matches pattern option to solve ur problem.
in matches pattern ( select country name or % for all).
now if u select particular country name then coresponding
data is displayed else use % to show all data for
country prompt
Is This Answer Correct ? | 0 Yes | 4 No |
What is the profile and package?
what is meant by report busting
Is there any other repository domains rather than universe, security, document?
How to change the order of prompts in universe?
why we are using derived tables ?how it will help?
What is global filters and local filters
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Explain when we use aggregate awareness function in designer?
how to make a report avilable to other users?
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in
When is the Repository created?