too many crosstable columns (357)"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i am generating a data, it starts but after few minutes it gives error as
"TOO MANY CROSSTABLE COLUMNS (357)", the numeric value keeps changing every
time if i repeat the data generation process.

i would like to know what is the cause of this error, and also the solution
on this.

thanks & regards
Senthil.
 
I would guess that the table that provides the field for the column headers
has more than 256 (or whatever the limit is) rows.
 
Senthil,

Is this a crosstab query? The message means that the column in the
original table (or precedent query) which you have chosen to be the
column headers in the crosstab has more than 255 - (Row Header Fields)
different values; 255 is the limit for columns.

HTH,
Nikos
 
Back
Top