error :

[div_1234]

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?

[rockytopmark]

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?   

[div_1234]

its measure.