Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2005-05-13
Medium Priority
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:Laura Munilla
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 13996342
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?  


Accepted Solution

Outin earned 500 total points
ID: 13997099
Other option: don't use crosstabs, but create a crosstab-like report yourself...


Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Loops Section Overview
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

581 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