Skip to main content
Solved

Display multiple attributes in one field - Report Designer


dpruckus
Freshman I
Forum|alt.badge.img

Hello. Im trying to display multiple attributes (values) in one field on the report. Cant seem to make it work. Any idea?

=[POLine.ProjectID] & [PMProject.AttributeProjectID]

Best answer by Robert Sternberg

I like to use the Concat function as it is more clear when viewing in the value property moving forward.  The + sign will also work.  

 

Here is a full function for the results. 

=Concat([POLine.ProjectID], [PMProject.AttributeProjectID])

You can also modify this by using different values in the arguments of concat. 

=Concat([POLine.ProjectID], ‘-’, [PMProject.AttributeProjectID])

=Concat([POLine.ProjectID], ‘ ‘, [PMProject.AttributeProjectID])

=Concat(‘PROJECT: ‘, [POLine.ProjectID], ‘PROJECT ATTRIBUTE: ‘, [PMProject.AttributeProjectID])

 

View original
Did this topic help you find an answer to your question?

4 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • May 9, 2023

Hello, Did you try + or comma ,  instead of & sign?


Robert Sternberg
Captain II
Forum|alt.badge.img+8

I like to use the Concat function as it is more clear when viewing in the value property moving forward.  The + sign will also work.  

 

Here is a full function for the results. 

=Concat([POLine.ProjectID], [PMProject.AttributeProjectID])

You can also modify this by using different values in the arguments of concat. 

=Concat([POLine.ProjectID], ‘-’, [PMProject.AttributeProjectID])

=Concat([POLine.ProjectID], ‘ ‘, [PMProject.AttributeProjectID])

=Concat(‘PROJECT: ‘, [POLine.ProjectID], ‘PROJECT ATTRIBUTE: ‘, [PMProject.AttributeProjectID])

 


dpruckus
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • 34 replies
  • May 9, 2023
Robert Sternberg wrote:

I like to use the Concat function as it is more clear when viewing in the value property moving forward.  The + sign will also work.  

 

Here is a full function for the results. 

=Concat([POLine.ProjectID], [PMProject.AttributeProjectID])

You can also modify this by using different values in the arguments of concat. 

=Concat([POLine.ProjectID], ‘-’, [PMProject.AttributeProjectID])

=Concat([POLine.ProjectID], ‘ ‘, [PMProject.AttributeProjectID])

=Concat(‘PROJECT: ‘, [POLine.ProjectID], ‘PROJECT ATTRIBUTE: ‘, [PMProject.AttributeProjectID])

 

Great! That worked!


Robert Sternberg
Captain II
Forum|alt.badge.img+8

@dpruckus Great news!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings