Kbase 21283: How Do I Display Array Fields in Actuate?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/10/2008 |
|
Status: Unverified
GOAL:
How To Display Array Fields separately in Actuate?
FACT(s) (Environment):
Actuate v4.x
Actuate v5.x
CAUSE:
By default, SQL-92 connections will display array fields as one semi-colon delimited field. An example of such a field from the Progress Sports2000 Database is the SalesRep.MonthQuota[1] ...[10] field.
FIX:
There are two ways to get around this default behaviour when using array fields in an Actuate report:
Parse the delimited data of the array field in Actuate Basic and display it in the report.
Create a view with the data from the field.
The second option of creating a view would be the more efficient way of doing this because the processing takes place on the Server rather than the Client. This method can use the pro_element function to retrieve specific elements from within an array field.