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 |
How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
---------------How to identify First Record and Last Record?
How to move reports one server to another server?
Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar
hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...
What DB View and Bus View?
Whrer u can save the Report net documentation in our local system?
What is difference between drill through and drill down?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
how you create security to reports?