Crystal Reports 3/VB4 Field too large?!!! 
Author Message
 Crystal Reports 3/VB4 Field too large?!!!

I have a database with "memo" fields that are more than 255 characters each.  
When I try to display the fields in Crystal Reports, only the first 50
characters are displayed.  Then it displays characters from the next field
listed on the CR report.  

I've already spent hours on it and can't figure it out.

Any help would be GREATLY appreciated.

-Rich W.



Thu, 30 Dec 1999 03:00:00 GMT  
 Crystal Reports 3/VB4 Field too large?!!!

Quote:

>I have a database with "memo" fields that are more than 255 characters each.  
>When I try to display the fields in Crystal Reports, only the first 50
>characters are displayed.  Then it displays characters from the next field
>listed on the CR report.  

>I've already spent hours on it and can't figure it out.

>Any help would be GREATLY appreciated.

>-Rich W.


To display a memo field in a Crystal Report, you must set the
"multiple lines" to true, and either specify 0 lines (unlimited) or
some set limit.  Right-click the text box, and select properties.  The
lower half of the properties dialog is the part that deals with that.


Fri, 31 Dec 1999 03:00:00 GMT  
 Crystal Reports 3/VB4 Field too large?!!!

I've already set the property to "multiple lines" but it still won't display
more than 50 characters.  If you can think of another possibility, please let
me know.

Thanks.

 Rich W.



Quote:

>>I have a database with "memo" fields that are more than 255 characters each.  
>>When I try to display the fields in Crystal Reports, only the first 50
>>characters are displayed.  Then it displays characters from the next field
>>listed on the CR report.  

>>I've already spent hours on it and can't figure it out.

>>Any help would be GREATLY appreciated.

>>-Rich W.

>To display a memo field in a Crystal Report, you must set the
>"multiple lines" to true, and either specify 0 lines (unlimited) or
>some set limit.  Right-click the text box, and select properties.  The
>lower half of the properties dialog is the part that deals with that.



Fri, 31 Dec 1999 03:00:00 GMT  
 Crystal Reports 3/VB4 Field too large?!!!

Crystal Reports does not handle Carriage Returns in a string of data.

Quote:

> I've already set the property to "multiple lines" but it still won't display
> more than 50 characters.  If you can think of another possibility, please let
> me know.

> Thanks.

>  Rich W.




> >>I have a database with "memo" fields that are more than 255 characters each.
> >>When I try to display the fields in Crystal Reports, only the first 50
> >>characters are displayed.  Then it displays characters from the next field
> >>listed on the CR report.

> >>I've already spent hours on it and can't figure it out.

> >>Any help would be GREATLY appreciated.

> >>-Rich W.

> >To display a memo field in a Crystal Report, you must set the
> >"multiple lines" to true, and either specify 0 lines (unlimited) or
> >some set limit.  Right-click the text box, and select properties.  The
> >lower half of the properties dialog is the part that deals with that.



Wed, 12 Jan 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

2. Crystal Report Pro shows only 130 fields in large table

3. VB4/Crystal Reports - Database field too big???

4. Crystal Reports/VB4 - Database field too big?!!!!

5. Crystal Report 4 - VB4 and Date Time Field

6. Crystal Report 3 - VB4 and Date Time Field

7. Need help printing LARGE reports with vb3.0 and Crystal Reports

8. Need help printing LARGE reports with VB3.0 and Crystal Reports 4.5

9. Formula field to table field name (Crystal Reports 8)

10. Crystal Reports Professional 7- Memo fields will not appear on report

11. Making Crystal Reports display memo fields without messing up other parts of the report

12. Using Crystal Reports 8.5 to Report Fields From Public Contacts Folder on Exchange 5.5 Server

 

 
Powered by phpBB® Forum Software