COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: ppgrwd on 29 Jul 2011 11:54:55 AM

Title: Converting Impromptu 7.1 and 7.4.4 reports to 7.5 (Report Issue)
Post by: ppgrwd on 29 Jul 2011 11:54:55 AM
Hi:
I'm converting Impromptu 7.4.4 reports to 7.5 and one Summary report is giving me a problem.  I also found the report in Version 7.1 and tried converting from this version to 7.5 with the same issue.
This report uses Groups and subtotals.  I have attached both the 7.4.4 version and 7.5 version with the same data prompts.  The grand total and total number of records retrieved is the same but only one detail record is displayed in the 7.5 version.  Has anyone else seen this? and know a fix without rebuilding the report from scratch????
Title: Re: Converting Impromptu 7.1 and 7.4.4 reports to 7.5 (Report Issue)
Post by: ppgrwd on 29 Jul 2011 02:27:25 PM
Hi Again:
Found the solution.
In 7.4.4 if you have the condition A <> '' and A is NULL then in 7.4.4 the condition is TRUE but in 7.5 the condition is FALSE.  I changed the statement to be "Not missing" and this works in both 7.4.4 and 7.5