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
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 |
Answer / moon
Ram's answer was perfectly currect...................
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
How u provide security to reports in report studio or in cognos connection?
Wt is the Diff between Business Key & member caption?
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
what is slowly growing dimension??
How can we find out cardinality between two tables?
can reportnet supports cubes???
What are the types of studio present in Cognos?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com
What is the use of content store in cognos?