Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 11 MAY 1998 12:32:51PM Andy Gilman wrote:

Multi-value options do not appear to work correctly with calculated fields in Revelation reporter.

I create a single record with one multi-value field (test_col) containing

two values: VALUE_1 and VALUE_2

I display this field on a report and it correctly shows:

(MV options are Treat as Multiple Records, If One Value Matches then Return All Values)

test_col

VALUE_1

VALUE_2

I then create a calculated field with formula @ANS={test_col}

I make this a multi-valued field and display it alongside the original

(with the same MV options). I get the following INCORRECT result:

test_col calc_field

VALUE_1 VALUE_1

VALUE_2

If I use "Treat as a Single Field" with comma separator, it is correctly dislayed as:

test_coL calc_field

VALUE_1 VALUE_1, VALUE_2

vALUE_2

Thanks in advance for any help.

View this thread on the forum...

  • third_party_content/community/commentary/forums_nonworks/8e0f57a6c6a6b24185256601005ae5ff.txt
  • Last modified: 2023/12/28 07:40
  • by 127.0.0.1