Skip to Content
avatar image
Former Member

The number of rows or columns exceeds its limit 65535

CRXI, ODBC database connection

My report uses a SQL statement command as the datasource. My SQL statement returns 30k records total. My crosstab is in a group header and no group has more than 10k records of this 30k. So technically each crosstab instance only has hit a max of 10k. I have only 1 column of summarized data. Yet my report returns this message. I can play around with different restrictions on the data (different where clauses) and can get the message to not appear. However I really can't tell how Crystal thinks I am exceeding this 65535 limit.

Does anyone have any insight into how Crystal is counting the number of rows or why I may be receiving this message?

Thanks.

Kurt

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 30, 2010 at 08:32 PM

    Nope, I sure don't... " I have Never heard of that one "

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Here is more detail about the crosstab.

      I have 9 Row fields defined in the crosstab expert (R1, R2, R3, R4, R5, R6, R7, R8, R9). Crystal will not repeat the row values on every row. This makes the report difficult to read unless you use gridlines (which I don't) and the report is not very Excel friendly in that format. As a result, my R1 field is actually a formula equal to R2R3R4R5R6R7R8+R9. I 'supress the label' for R1 and then the row values are repeated on every row, because R1 is unique for every row. If I remove R9 from the R1 formula I do not get the error. Leaving R9 in the formula produces the error.

      It still does not make sense because there are only 30k records. The unique combination of R2R3R4R5R6R7R8+R9 on 30k records cannot be more than 30k (or 65535).

      If I remove R1 as a crosstab row I no longer receive the error, however, row values are not repeated on every row. So I can eliminate the R1 formula row and my error if I can come up with another trick for repeating the row values on every row.

  • Jun 30, 2010 at 05:50 PM

    Hi Kurt,

    When does this error happen? I usually see this when exporting to Excel because that would be the row limit in Excel.

    To see what Crystal's doing, make a copy of this report and remove the crosstab. Drop a field into the Detail section and run the report.

    How many records does Crystal say it returns in the Record Count when you preview the report? If it shows more than 30,000 records then possibly look at your joins.

    If you are exporting to Excel, sometimes an extra row is created for each row in the Crosstab. Go into the Crosstab Expert and in the Customize Style tab. At the bottom, remove the check from Show Cell Margins. This will remove the extra spacing that creates the extra rows and columns between your fields.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The error occurs when I preview the report. It has nothing to do with exporting to Excel.

      I removed the crosstab as you suggested and Crystal is showing that it is reporting the 30k records only. So still perplexed why the crosstab thinks there are more.

      Thank for your suggestion.

      Kurt

  • avatar image
    Former Member
    Jun 30, 2010 at 07:23 PM

    Complete wild question, does it make any difference what type of printer you have selected?

    Also what version of CR are you on?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 30, 2010 at 07:25 PM

    Sorry, did not mean version I see you said CRXI, what is your release?

    I am on 11.5.12.1838 (Which I am farily sure is SP6 (The last of the updates for this product)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Just to clarify, this error occurs only with a crosstab. Are you able to pull 1.5 million records into a crosstab? Crystal documentation clearly states the 65535 limit for a crosstab (at least my version). But as far as I can tell, I am no where near that limit.

  • avatar image
    Former Member
    Jul 01, 2010 at 01:31 PM

    Just for snicks and grins, how about creating a few more formulas

    Form1 R2R3R4+R5

    Form2 R6R7R8+R9

    Form3 {@Form1}+{@Form2}

    Then use the Form3 in the Crosstab, just to see if the error goes away.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Don Williams

      Thanks, Don.

      However my report is based on an SQL command or stored procedure. I don't think I am able to use the Btrieve DDFs for this type of reporting, am I?