Merge Two Fields

[Marcel]

Hello everyone,

Please, I need a little help with Report Designer. I have 2 fields(Name and CompanyID) and I want to concatenate them. Some rows from column Name are populated with company name and other are blank. All rows from CompanyID are populated with guids. I tried something like {Fields.Name}{Fields.CompanyId}, but all rows which are populated with the company name, also added guids. I want all the rows that are populated with the company name not to add guids, too.

Thanks in Advance!

[Mads]

Hello Marcel,

From my understanding you want to display the field 'Name'. If this field is empty, you instead want to display the field 'CompanyId'.

We can use the conditional function IIF( ) to check if the field 'Name' is blank. But blank can both mean that the field is null, and that the field is an empty string, so we need to check for both. I suggest using the following expression:

= IIf(Fields.Name Is Null Or Fields.Name Like "",Fields.CompanyId,Fields.Name)

This will check if the field 'Name' is Null or is like "" (empty string), then use 'CompanyId' if either of these is true.

I hope this information is useful. Let me know if I understood your requirements correctly and if I answered your question. If you have any other questions, please let me know.

Regards, Mads Progress Telerik

[Marcel]

Thank you, this is what I needed.