Skip to main content
Answer

Schema Builder and Report Designer Help

  • September 23, 2025
  • 1 reply
  • 40 views

cramesh00
Freshman II
Forum|alt.badge.img

I am trying to modify the canned Shipping Confirmation report to include a “Sold To” section that would show the location info for the customer who “purchased” the goods as the report already displays the “Ship To” info which is different at times.

When I started to add in Customer.AcctName into the Expression Editor, upon validation I got the following error message:
The expression contains an invalid name. ‘[Customer.AcctName]’ 

I realize this needs to be setup in the schema builder, but so far, each time I try to modify a link or add one even, I break the entire report. Any help is welcomed!!

 

Best answer by Zalman

Hi

After reviewing your expression, i see an added [ in front of the first instance of [Customer.AcctName]. If you remove it, this should no longer be an error. 

 

Current 
=IIF([[Customer.AcctName]<>null,[Customer.AcctName]+'{br}','')

To
=IIF([Customer.AcctName]<>null,[Customer.AcctName]+'{br}','')

1 reply

Forum|alt.badge.img+1
  • Jr Varsity I
  • Answer
  • October 20, 2025

Hi

After reviewing your expression, i see an added [ in front of the first instance of [Customer.AcctName]. If you remove it, this should no longer be an error. 

 

Current 
=IIF([[Customer.AcctName]<>null,[Customer.AcctName]+'{br}','')

To
=IIF([Customer.AcctName]<>null,[Customer.AcctName]+'{br}','')