Solved

Cognos expression result  is not being displayed in report

Posted on 2011-09-09
4
543 Views
Last Modified: 2012-05-12
Hi,

In the crosstab report I am using one of the expression as

if([Type]= 'M') then('Mag zines.') else('book')

so it shows the count of each for a store.. But if that store does not have magzines  for a time period(like Quarter)  then it should display '0' but it is not pulling that column at all.

It is just  pulling book and displaying its numbers.
0
Comment
Question by:new_perl_user
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:SNeupane
ID: 36511638
It could be because of null suppression that is automatic in crosstab.
Change expression of your measure to coalesce () or nullif or (if null then 0 else measure) etc... expression.
Use the one that works according to your database.
0
 

Author Comment

by:new_perl_user
ID: 36512672
the [Type] data item I am using above is text  so when I am using coalesce () it errors out.

If possible can you please let me know how to use nullif and others with an example of condition/expression
0
 
LVL 8

Accepted Solution

by:
SNeupane earned 500 total points
ID: 36512868
then use a if else statement to check for null and if null put '0' value.
0
 

Author Comment

by:new_perl_user
ID: 36513157
how doe we check for a null from the above expression

if([Type]= 'M') then('Mag zines.') else('book')
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question