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

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

1821


what are the special features in cognos reportnet?

821


what is catalog and types of catalogs in cagnos and which is better?

902


What are the advantages of shortcuts?

734


What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

1828


Define cognos report net?

738


what is online view?

1721


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1784


How to generate cubes in cognos?

751


What are initial page components of Cognos connection?

809


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

789


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1898


What is the difference between regular dimension and derminant?

1921


What is the use of powerhouse?

810


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1775