Array Memo Field in Formula with CR 8.5

[nisccrystal]

Just wondering if anybody has a solution for this. I am working with a progress database at the 9.1D-09 level. I have a memo field defined that has 16 array elements with each element being 60 characters long. I need to extract those array elements that have information in them and put them on the CR report. I have tried the SQL Expression idea and did not have any luck with that. Does anybody have any solution to fix this other than going to a higher level of Crystal ?? Any help would be greatly appreciated.

 

[rosemaryl]

Dear NISCCRYSTAL,

What was the sql expression you tried?

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[nisccrystal]

I tried the following two statements.

{fn SUBSTRING(SI_SRV_ORD_MSTR."SI_REQUEST",1 ,60 )}; This statement I just tried to see what would happen.

pro_element(SI_SRV_ORD_MSTR."SI_REQUEST",1,1) This statement was the one I wanted to use because this would get the the first element of the array.

I got the following error "Error in Compiling SQL Expression : Invalid Function Found Here"

Thanks

Dan

 

[rosemaryl]

Did the first statement, the substring not work or did it work?


I have never heard of the function pro_element?

What database are you using? Progress? I have never used Progress, but if it is a valid function for your database in a "Query" you might try doing a select and placing the expression in ()..

Like this:

(Select pro_element(SI_SRV_ORD_MSTR."SI_REQUEST",1,1)
FROM MyTable
Where MyTable."PrimaryKey" = ReportTable."PrimaryKey")

With MS SQL Server or Oracle you can use a query tool like SQL Query Analyzer or SQL Plus to test the statement by replacing the = ReportTable."PrimaryKey" at the end with a valid record id.

I hope that helps,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762