Memo fields

[mgakhar]

Hi,
Im new to Crystal Reports and so probably this is a fairly basic question I hope.

Im using OLE DB in CR to connect to a proprietary Object Oriented Database. After making the connection, I use Add Command and paste my SQL in the command. The problem that I have is that all the string fields in the database show up in Crystal as Memo fields.

If instead of using the Add Command feature, I directly select a table into Crystal and view the fields, then CR displays the data type correctly as String. However, since my query is very complicated I need to use the Command feature.

Since most of the critical fields show up as memo I cant use group by feature or sort the records.

Any help will be greatly appreciated !!!

Note - Im using CR version 10.

thanks,
MG.

 

[synapsevampire]

Interesting...an exanmploe of part of the select protion of your query would have been helpful.

One solution may be to wrap each field in the select in a CAST or CONVERT function to set it back to the proper data type.

Otherwise let's have a look at the select portion.

-k

 

[mgakhar]

Hi synapse,
Well unfortunately the query doesnt allow to cast or convert the field to a specific type of data.

Here is an example of a very simple query -
select 'John Doe' as Name, BOWarehouseItem.code as Item
from BOWarehouseItem
where BOWarehouseItem.code = 'BOX123'

So now with this example when I check the datatype for Name and Item fields it shows as Memo. Not sure if this is a CR problem or a DB related issue.

MG.

 

[mgakhar]

Just wanted to update this thread that I found a way to fix this problem. Basically I created a formula field with coded as ToText ({Command.Item}) and then used this field on the report and used it to create group.

If anyone has a better solution please do reply.

Manish.

 

[synapsevampire]

It's likely the database connection.

Sounds like your solution is fine, however it's odd that it changed the datatype...

-k