Interested to Buy Any Domain ? << Click Here >> for more details...
I have a value prompt in my prompt page.Now if I set the
filter to required then I have to select a value from the
list and I will get the respective data in the report
page.But If I select nothing then I will get the complete
data in the report page.
I want that if I select nothing from the prompt list then
nothing is displayed in my report page.
How should I do this?
- 1 Answers
- 6697 Views
- Cap Gemini, HSBC, I also Faced
- E-Mail Answers
Answer / naresh
For this , you have to make static prompt values.
while making static prompt values create one empty value this will gives no data when you run the report with no value.
----------------------------------
But generally ,
If you are making filter is required , while running it won't highlight the Finish button if you are not selecting value,so without selecting values you cannot run the report.
If you are making filter is Optional means it will consider no prompt/filter if no value selected from prompt, it will allow to run the report.
So based on above two cases , second case is not preferable to run the report.
| Is This Answer Correct ? | 11 Yes | 2 No |
Can you define pivot?
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
How to hide value prompt box and list when run report?
What are the advantages of shortcuts?
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this
difference between drill through and master detail report?
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
Can you define dimension?
Teradata 
