on 2009 Jan 26 1:54 AM
I have a memo field on the report that is truncating the characters in the field to 255 characters. It is resizing (Can Grow is checked) and if I narrow the width the field does resize in height. I have verified the text exists in the database, but I cannot get it to show on the Crystal Report. I suspect this is an issue with Access as I have never had this issue with other data sources. Any help??
Try verifying the database to see if the struture of the table has changed. then see if the memo field is truncated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Theresa,
1. What type of connection are you using (ODBC / OLE DB / Native)?
You can try using the Crystal Drivers for CR 2008, from the link provided below, create the DSN connection using these drivers.
https://smpdl.sap-ag.de/~sapidp/012002523100008666562008E/cr_datadirect53_win32.zip
Hope this helps you.
Regards,
Abhijeet T.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I started the install of these drivers but did not continue because my db is Access and I am not sure how to set that up (I am trying to connect dynamically to my Access DB on FTP site but have different thread open for that).
I actually found a different solution that appears to be working. I created a Command and wrote a short query to the database that pulls in only the memo field and my link to the primary table. I am now getting my complete memo field.
Hi Theresa,
In Crystal, do you see that field type as Memo ?, What is the datasource you are using ? If you have problem in pulling data into your report, check the datasource. Try to use other datasource like OLE DB etc and check.
Thanks,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
13 | |
11 | |
10 | |
9 | |
9 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.