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

What is set to be cardinality?

732


Explain what is the difference between native sql and cognos sql?

631


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1573


Can you define bitmap index?

684


What are the methods by which it non-durable model could be changed into the durable model?

594






3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2227


What are the components used in web tier?

633


How do we convert from Numeric to be Words?

2578


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

1728


how can I test reports in cagnos?

735


What is defined as data mining?

677


Define cognos report net?

642


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1614


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

1675


What is difference between page break and section report?

799