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?

Answers were Sorted based on User's Feedback



Suppose you have a report with no data , when you run the report in report studio how can you tell..

Answer / ram

In Cognos8.3 report studio proparties pan there is a
proparty called No data contents by default it shows No .
We can set that proparty to Yes. In the report pagebody we
will find one tab called no data content. there we can use
the text you can tell the end user there is no data

Is This Answer Correct ?    30 Yes 1 No

Suppose you have a report with no data , when you run the report in report studio how can you tell..

Answer / moon

Ram's answer was perfectly currect...................

Is This Answer Correct ?    1 Yes 0 No

Suppose you have a report with no data , when you run the report in report studio how can you tell..

Answer / ram_cog

Use No data pane option

Is This Answer Correct ?    0 Yes 0 No

Suppose you have a report with no data , when you run the report in report studio how can you tell..

Answer / 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

Suppose you have a report with no data , when you run the report in report studio how can you tell..

Answer / guest

Suppose there is no data in the report, when you run the
report, only the title will be displayed, data part will be
empty.

In such scenario, you have tell the user that the selection
criteria is not met with the business rules.

Eg. user run "monthly stock report" with selection of "week-
15" as time selection, will not display the record.
because, this report associated with calander month, so any
month has to be selected.. Last date of the month is
considered for monthly stock report.



rgds,
-palz-


Is This Answer Correct ?    2 Yes 8 No

Post New Answer

More Cognos Interview Questions

what is requery in cognos?

0 Answers   HMN, Satyam, TCS,


What is the use of powerhouse?

0 Answers  


What do you mean by query studio?

0 Answers  


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

0 Answers  


how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

6 Answers   HCL,






what is crosstab space

1 Answers   IBM,


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?

0 Answers   TCS,


Wt is the Diff between Business Key & member caption?

2 Answers  


What is the enterprise class platform architecture of cognos 8?

0 Answers  


wat is bus schema?

2 Answers  


write a query to display to 10 max record from the employee table?

2 Answers   HCL,


Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,


Categories