harryhazza
asked on
The page size was not large enough to format the contents of an object in the report
Using Crystal 8.5 with an ODBC connection to MS SQL server
I have a 4000 character memo field in the report. The memo field will not go across two pages, it always errors with "The page size was not large enough to format the contents of an object in the report"
I have a seen a solution mentioning breaking the field up into sections and using a page break..
I tried to use a SQL expression to break it up
{fn SUBSTRING ( ev_events."notes" , 0 , 250 ) }
Although this errors in the report editor, it does actually work, the problem is, the user may enter the note in a columnar fashion like
1./ Note1
2./ Note2
3./ Note3 etc doing this the user may only be able to enter 30 or 40 charaters before the end of the page is reached, so my alowance of 250 chars then a page break is useless.
Does anyone have any ideas..?
I have a 4000 character memo field in the report. The memo field will not go across two pages, it always errors with "The page size was not large enough to format the contents of an object in the report"
I have a seen a solution mentioning breaking the field up into sections and using a page break..
I tried to use a SQL expression to break it up
{fn SUBSTRING ( ev_events."notes" , 0 , 250 ) }
Although this errors in the report editor, it does actually work, the problem is, the user may enter the note in a columnar fashion like
1./ Note1
2./ Note2
3./ Note3 etc doing this the user may only be able to enter 30 or 40 charaters before the end of the page is reached, so my alowance of 250 chars then a page break is useless.
Does anyone have any ideas..?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc