Array Field 1

[jbaldO]

hi,
im new to crystal, so i need help on this.
im using progress v9 database and crystal 9.
i need to write a report with a parameter on an array field.. any ideas? thanks.

 

[synapsevampire]

Please describe the array field as Crystal doesn't support arrays in databases directly that I'm aware of.

Do you mean a character delimited field, or?

-k

 

[jbaldO]

Hi, thanks for the reply.

It is actually an array field as Progress supports array field.. it is a character field with an extent of 10. Was able to figure how Crystal handles the field. Crystal actually reads the field as a comma separated string. Used Split and Left function to get the array element i want. Now, my problem is the report is very slow (probably because of the string manipulation involved).
My questions now are:
1. Any idea how to improve performance on this kinds of report?
2. I am using 2 databases and when i display my SQL query using show sql query, it only displays the part on the 1st database not the complete sql query.
3. any way of writing SQL statement and pasting it somewhere in Crystal to use as sql of the report?

Thanks.

 

[GJParker]

IN CR9 you can use the Add Command functionality to use your own SQL.

This can be found with your database connection in the database expert.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[synapsevampire]

Yeah, alot of supposed array data types are merely CSV, that's why I asked.

Depends on the databases involved. Are they both Progress?

If not, it's going to be slow until you LINK the servers or create a common repository.

-k