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?
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
How to do Performence Tunning in Cognos Reports?
in u r data u having duplicates how to fetch the latest data in our report?
How to select multiple values from type-in prompt?
How create measures and demensions?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What do you understand by user class in cognos?
What are the different uses of a repository manager?
how to connect datamarts
--------------Diff b/w ODS and OLAP?
What do you mean by Drill down and Drill Up?
Can you define a catalog and types of catalogs in cognos?
Define olap designer?
Can you explain the advantage of using shortcuts?
what do u mean by bridge group? where we r using this one?
What do you mean by query studio?