Maximum number of rows available in Crystal Cross-Tab

[Former Member]

Is there a limit to the number of rows you can have in a Cross-Tab in Crystal? Right now I have about one page full (less than 50). Every time I add another row, I get the "Error formatting Cross-Tab Object" message in preview mode. I can remove items and add any row, so it is not a particular object that is giving me an issue, just once I get to the magic number.

Crystal version = 12.1.2.996

Any idea? Thanks.

Edited by: Mike Buff on Apr 8, 2009 10:20 PM

[Former Member · Accepted solution]

Hi Mike,

This is a known issue in Crystal Reports and has been assigned Track ID ADAPT00055049.

This occurs because the 'Keep together' option is not selected for the group where the crosstab has been inserted.

To resolve this issue, complete the following steps:

1. From the 'Format' menu, click 'Section'. This launches the 'Section Expert'.

2. Click the group that contains the crosstab and select 'Keep Together'.

3. Click the 'OK' button to close the 'Section Expert' dialog box.

Now, when you refresh the report, you will not receive the error.

[Former Member · Accepted solution]

Vinay,

The "Keep Together" option is already selected. Any other ideas?

By the way, I'm using the report header section.

Thanks.

Edited by: Mike Buff on Apr 8, 2009 10:41 PM

Edited by: Mike Buff on Apr 8, 2009 11:00 PM