Print Page - error :

Title: error :
Post by: div_1234 on 21 Sep 2011 09:28:45 PM

HI

i am getting error like 'sqlScrollBulkFetch' status='-239'. i have cast my field (comes from stored procedure) cast(period,int) and then in crosstab i have used following

layout calculation,

string2date(substring (number2string ([Query1].[period]),1,4)
+'-'+
substring (number2string ([Query1].[Period]),5,2)
+'-'+
substring (number2string ([Query1].[Period]),7,2))

i m getting error like 'sqlScrollBulkFetch' status='-239'

Any help?

Title: Re: error :
Post by: rockytopmark on 26 Sep 2011 01:19:07 PM

You may want to include the details of the error message.

Also, why are you using a layout calculation, as opposed to a Query Calculation? Crosstabs are based on Queries... Where is the layout calc within the crosstab... Row edge? Column edge? Measure?

Title: Re: error :
Post by: div_1234 on 27 Sep 2011 11:27:32 AM

its measure.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: div_1234 on 21 Sep 2011 09:28:45 PM