Suppose you have a report with no data , when you run the
report in report studio how can you tell the end user ,
that it has no data , while he runs it?Is it possible ? if
so how?
- 5 Answers
- 12364 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / viswa
It is possible when u have prompt in prompt page... suppose
u take one list in main page... the list query u will assign
the page.... and take conditional block and drag the after
list and take one text item drop after conditional block...
in ur list have year, product line,quantity..... and take
the year in prompt page as text prompt.... go to conditional
explorer u will take string write condition like this...
if(product line is null or product line='') then *('hide')
else ('show')and come to main page select the conditional
conditional block.. go to conditional explorer select the
string as hide and come to properties pane select the
current block choose hide and come to main page take the
text item drop at the conditional block....and again select
the conditional block go to properties pane select the
current block as show and come to main page take entire list
and drop at the conditional block.......
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
-----------Diff b/w OLAP and RDBMS?
what is the difference between querystudio in reportnet and cognos8
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Can you define drill across?
What are all the types of report?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What are types of batch available in cognos?
What is the difference between static and dynamic conditions?
Can you define set to be cardinality?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Can you define cube?
write a query to display the departments with no employee?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What are the considerations regarding performance kept in mind while setting up cognos?
What do you mean by Drill down and Drill Up?
