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


Please Help Members By Posting Answers For Below Questions

How to do Performence Tunning in Cognos Reports?

2270


in u r data u having duplicates how to fetch the latest data in our report?

5262


How to select multiple values from type-in prompt?

858


How create measures and demensions?

831


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

1936


What do you understand by user class in cognos?

734


What are the different uses of a repository manager?

823


how to connect datamarts

2582


--------------Diff b/w ODS and OLAP?

2984


What do you mean by Drill down and Drill Up?

765


Can you define a catalog and types of catalogs in cognos?

804


Define olap designer?

924


Can you explain the advantage of using shortcuts?

831


what do u mean by bridge group? where we r using this one?

1753


What do you mean by query studio?

725