Value of Concatanated Field

[Stokesy]

within a formula field i have concatanated a field name within one of my tables (as the suffix will change depending on separate data).

I wish to view the *value* of this field within my report. How do I go about this?

Thanks,
James

 

[tmcain]

Have you tried assigning the "value" to a variable? You could then have a formula field to print out the variable.

I hope this helps!

 

[Stokesy]

I have assigned the field name to a variable but then when I place it on the report it just gives me the variable name. How do I get the actual value of the field?

Thanks for your help
James

 

[tmcain]

Try this

whileprintingrecords;
numbervar x;
x

of course intialize the variable with whatever type it is, string, etc.

hope this helps

 

[IdoMillet]

I believe there is no built-in way of doing this
within Crystal (you could do this by creating a dll
to introduce a new user-defined function into
Crystal.

You may want to consider an alternative whereby
the report retrieves all possible fields and selects
the appropriate one based on the text value.

Cheers,
- Ido ixm7@psu.edu