How to retrieve single value from a field

Hello,

in our program I have created various fields that contain tabular data. For instance I have a field called AA_to_MP which contains a table of 10 values. When designing a report, I would like to be able to retrieve individual values from this field and add them to the report as I would a variable. For instance, I would like to be able to retrieve “AA_to_MP(0)” to get the first value in the field. Is that possible? Or will I have to create separate variables for each of those 10 values? Thank you.

Vijay

Hello Vijay,

thank you for your post.

Depending on how you want to use the values it might be easier to store each of them in a separate variable.

Otherwise you can use given or self-created designer functions to return the desired value. For example you will print the next two digits after the first occurance of a separator (e.g. a pipe, semicolon, space, …), but this might be a bit to complex to recommend and has to be done for every appearance of any of the values.

Best regards,

Patrick Preuschoff
Technical Support
combit GmbH