Database Field of "Memo type" in crystal report

[manush]

Hi,

I have two fields in oracle as below

component_alias not null VARCHAR2(32)
attribute_address not null VARCHAR2(2000)

I am using a select query in my package as below

select component_alias "Alias", attribute_address "Address"
from component_header;

Now I am calling this package from a crystal report where in Field Explorer, (in Database field section) the fields are coming as below.

Alias: String(32)
Address: Memo

Now the problem is this, that Address is coming as Memo, instead of VARCHAR2(2000). I have to group the report on address but grouping is not possible on Memo.

I don't know about Memo. Please suggest the solution.

Manoj

 

[pgtek]

hi
check this

http://support.businessobjects.com/...x_ver=&index_lang=&indexq2=&indexq3=&indexq4=

cheers

pgtek

 

[manush]

Hi,
thank for your reply..
The link says to create a function on memo type and use this in group but I am facing two problems.

1. The memo field doesn't comes in the formula editor so how can I create a formula on this.

2. I created another formulata (just for test purpose) but while creating the group on this, the OK button of insert group is not highlighting.

I am using Crystal 8.5

Manoj