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.
I am using VS2012 and corresponding Crystal Report for VS from SAP.
None
0 Points
4 Posts
Break a large text field at page break
Jun 17, 2014 10:48 PM|geonav|LINK
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.
I am using VS2012 and corresponding Crystal Report for VS from SAP.
Any suggestions?
Member
594 Points
385 Posts
Re: Break a large text field at page break
Jun 19, 2014 12:44 AM|aspsak|LINK
Hi,
You may try with VARCHAR(Length) instead of VARCHAR(MAX) .
I think the limit is VARCHAR(999) .
None
0 Points
4 Posts
Re: Break a large text field at page break
Jun 20, 2014 10:27 AM|geonav|LINK
But the SQL Server VARCHAR(MAX) field can grow up to 8000 characters. How do I handle it then?
Member
594 Points
385 Posts
Re: Break a large text field at page break
Sep 24, 2014 03:00 AM|aspsak|LINK
http://stackoverflow.com/questions/5175361/crystal-reports-with-sql-server-using-varchar-with-more-than-8000-characters