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 need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
Types of Performance Tuning?
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
How to hide/unhide the prompts which are not used by unauthorized users?
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
Give me any example of semi and non additive measures?
What is use of Field Set present in toolbox?
What are cognos connection initial page components?
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
can we join 2 different queries? One has 10 columns and other has 5+ columns?