Number of rows exceeds the limit error in crosstab in crystal 10

Posted on 2005-05-13
1 Endorsement
Last Modified: 2008-02-01
I have a crosstab that is not running.  I get the following error:

"The number of rows or columns is too big. Try limiting the number of unique group values.  Details: The number of rows or columns exceeds its limit, 65,535.

Does anyone know how to deal about this error?

I am simply counting a combination of field 1 and field two.
Question by:Lmunilla
    LVL 26

    Expert Comment

    by:Kurt Reinhardt
    Yes, filter your report so that it returns less records.....

    Unless I'm mistaken, this error message is pretty clear.  Since you only have two fields, the number of columns probably hasn't been exceeded, but the number of rows has.  What is your record selection criteria?  

    LVL 9

    Accepted Solution

    Other option: don't use crosstabs, but create a crosstab-like report yourself...


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now