SSRS Consultant`

Epicor ERP 10
8

Hey everyone.

I was able to resolve this via UNION this has been racking my brains for months now. I don’t understand why I didn’t think of this before.

I have do have one more small question.

CONCAT_WS(', ', 
          Customer.Name, 
           Customer.Address1, 
           Customer.Address2,
           Customer.Address3,
           Customer.City,
           Customer.State,
           Customer.Zip,
           Customer.Country)

Coming back with

image

I’m trying to format the address to remove blanks and have a clean address e.g 10 Downing St, London SW1A 2AA rather than 10 Downing St,,,London SW1A 2AA

The extra two ,, are address 2, 3

Any ideas?