I HAVE USED A PROMPT TO SELECT A COUNTRY
IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN
DEFAULT AND HAVE TO GIVE THE RESULT?
HOW TO ACHIEVE THIS?
Answers were Sorted based on User's Feedback
Answer / satish yandamuri
You just drag the country object in filter object select the operand as promt, then left side of the operand you could see blue color bubble when you double click on that you will get a promt properties, there you can see the default LOV option, there select India as a default LOV, then when a movement you refresh the reprot, it will show India as default LOV.
Cheers,
Satish Yandamuri
| Is This Answer Correct ? | 25 Yes | 1 No |
Answer / reddy
yes .We can give value INDIA as a constant into the
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sudhakar
ACCORDING TO YOUR REQUIREMENT I UNDERSTOOD THAT YOU WANTED
TO PASS A DEFAULT VALUE TO YOUR REPORT AS INDIA.
YOU CAN ACHIVE IT BY FOLLOWING BELOW STEPS:
1: CREATE A BLANK REPORT
2:INSERT YOUR REPORT AS A SUBREPORT TO THAT BLANK REPORT.
3:CREATE A FORMULA IN THE BLANK REPORT AS INDIA(WRITE INDIA
THE WROK SHOP)
4: WHILE LINKING THE SUB REPORT YOU NEED TO LINK WITH
PARAMETER AND THE BLANK REPORT FORMULA.
5: SO THAT ON THE FLY PARAMETER GOT ASSIGN TO INDIA
EVERYTIME AND YOU WILL GET DATA OF INDIA IN THE REPORT.
NOTE: YOUR REPORT SHOULD NOT CONTAIN ANY SUBREPORT.
| Is This Answer Correct ? | 0 Yes | 12 No |
Explain about derived tables?
Can i merge two dataproviders if they do not have common column?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
Steps to create alias and apply
limitaions of cross tab ?
How to generate the report from excel sheet?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
what is dashboards? what is metrics?
How do you restrict access to rows of a database?
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
What is the use of AFD? Where it can be stored?