I have a Crystal Report which is populated by a sql server stored procedure. Out of the 12 fields, two contain out put of VARCHAR(MAX) fields of SQL Server tables. These fields are placed in separate Details Sections to ensure that they can grow while retaining relative positions.
When the text fields are populated with a large text value (sometimes more than a page length), a part of the field just disappears after the page break. The remainder is not shown on the next page. More surprisingly, when I return back to the previous page where the text field started, the content is different from what was there in the biginning! The large field values are not visible at all!
If I export the report, the large field values are not seen only.
Is there any size restriction for Crystal Report text fields? More importantly, Is it possible to insert a pager break to the section when it is displaying the large text?
I tried playing around with 'Keep Together' property of the text field as well as the section. No success.
Any suggestions?