Blob field or Memo field workaround?

[DianaStewart]

I am viewing my reports by typing in the url in the browser like this:

http://server/folder1/Report.rpt

It was taking a long time to display, the performance was very slow. So the suggestion was made to convert the connection to my Access database from Direct to ODBC. I changed the connection to ODBC and encountered this error:

Blob field or Memo field cannot be used in a formula.

I understand that any fields that are > 254 will be converted to a memo field and Crystal reports does not work with memo fields.

So I went into my Access database and changed the field from 255 to 250 characters.

I reran the report and it still gave me the same message...

Strange thing is in my database the field will show as 100 characters but when I view the field from within the Report Designer it shows as 200 charcters????!!!!!

Here is the formula where I keep encountering the blob err message:

if {Table1.Description1} <> &quot;N\A&quot; then {Table1.Description1}
else if {Table1.Description2} <> &quot;N\A&quot; then {Table1.Description2}
else if {Table1.Description3} <> &quot;N\A&quot; then {Table1.Description3}
else if {Table1.Description4} <> &quot;N\A&quot; then {Table1.Description4}


How can I get around this without modifying the database physically?

Help
Diana

 

[MrWilly]

Did you run a &quot;Verify Database&quot;?
This will allow you to fix your report if any changes to the db tables/fields have been made.

It will allow you to remap your fields.

 

[rosemaryl]

Dear Diana,

Have you applied SP1 for Crystal 8.5? This fixes an issue with some databases where the field size differs between native and odbc connection.

http://support.crystaldecisions.com/fix/hot/si75/form.asp?file=cr85win_en_sp1.exe

HTH,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.