COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cfsindorf on 09 Mar 2011 11:07:44 AM

Title: Singleton
Post by: cfsindorf on 09 Mar 2011 11:07:44 AM
I have 2 crosstab s on one report.  I want to take one of the totals from each and add them together in a singleton.  I did this in a report with lists but cross tabs are giving me fits.

I keep getting:
QE-DEF-0360 The query contains a reference to at least one object '[SigmaFlow].[ProjectID]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature.

no matter what I try.

Craig
Title: Re: Singleton
Post by: rockytopmark on 09 Mar 2011 12:32:49 PM
I have seen this error before, and it was handled by simply renaming my Report Queries.  I had a query named exactly the same as a Query Subject in my model, and it confused Cognos at run time.

Its a shot in the dark, but what the heck... maybe it is the same problem you have!!

HTH, M