Complicated formula doesn't work in 2D barcodes

[Jennypi]

Hello,

I'm trying to fill out a 2D barcode (QR or datamatrix) with a complex calculation, but it would add a red frame around the bar code component and adding "Not valid data".
I know the code works, as it gives the good result in a classic text component.
How can I do?
Is there a workaround by getting the text component text to fill out the barcode?

Thanks

Code: Select all

{IIF(data.alt_name == "Yl", "Yl",
IIF(data.alt_name == "FILL", "FILL",
IIF(data.project == 181,
IIF(data.ID == "",
IIF(data.line_name.Substring(1,1) == "M",
data.line_name.Substring(3,2) + "MXS" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
IIF(data.line_name.Substring(1,1) == "D",
data.line_name.Substring(3,2) + "D" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
data.line_name.Substring(3,2) + data.line_name.Substring(1,2) + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3))),
data.ID),
IIF(data.project == 182,
IIF(data.ID == "",
IIF(data.line_name.Substring(1,1) == "M",
data.line_name.Substring(3,2) + "MXF" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
IIF(data.line_name.Substring(1,1) == "D",
data.line_name.Substring(3,2) + "D" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
data.line_name.Substring(3,2) + data.line_name.Substring(1,2) + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3))),
data.ID),
IIF(data.project == 184,
IIF(data.ID == "",
IIF(data.line_name.Substring(1,1) == "M",
data.line_name.Substring(3,2) + "MXP" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
IIF(data.line_name.Substring(1,1) == "D",
data.line_name.Substring(3,2) + "D" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
data.line_name.Substring(3,2) + data.line_name.Substring(1,2) + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3))),
data.ID),
IIF(data.ID == "",
IIF(data.line_name.Substring(1,1) == "M",
data.line_name.Substring(3,2) + "MX" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
IIF(data.line_name.Substring(1,1) == "D",
data.line_name.Substring(3,2) + "D" + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3),
data.line_name.Substring(3,2) + data.line_name.Substring(1,2) + data.line_name.Substring(7,4) + "-" + data.line_name.Substring(11,3))),
data.ID))))))
+" - Dis:"+data.dis_notes+ " - "+
IIF(data.p_female_name == "Yl", "Yl",
IIF(data.p_female_name == "FILL", "FILL",
IIF(data.p_female_project == 181,
IIF(data.p_female_ID == "",
IIF(data.p_female.Substring(1,1) == "M",
data.p_female.Substring(3,2) + "MXS" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
IIF(data.p_female.Substring(1,1) == "D",
data.p_female.Substring(3,2) + "D" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
data.p_female.Substring(3,2) + data.p_female.Substring(1,2) + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3))),
data.p_female_ID),
IIF(data.p_female_project == 182,
IIF(data.p_female_ID == "",
IIF(data.p_female.Substring(1,1) == "M",
data.p_female.Substring(3,2) + "MXF" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
IIF(data.p_female.Substring(1,1) == "D",
data.p_female.Substring(3,2) + "D" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
data.p_female.Substring(3,2) + data.p_female.Substring(1,2) + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3))),
data.p_female_ID),
IIF(data.p_female_project == 184,
IIF(data.p_female_ID == "",
IIF(data.p_female.Substring(1,1) == "M",
data.p_female.Substring(3,2) + "MXP" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
IIF(data.p_female.Substring(1,1) == "D",
data.p_female.Substring(3,2) + "D" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
data.p_female.Substring(3,2) + data.p_female.Substring(1,2) + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3))),
data.p_female_ID),
IIF(data.p_female_ID == "",
IIF(data.p_female.Substring(1,1) == "M",
data.p_female.Substring(3,2) + "MX" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
IIF(data.p_female.Substring(1,1) == "D",
data.p_female.Substring(3,2) + "D" + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3),
data.p_female.Substring(3,2) + data.p_female.Substring(1,2) + data.p_female.Substring(7,4) + "-" + data.p_female.Substring(11,3))),
data.p_female_ID))))))}

[Ivan]

Hello,

Can you please send us a sample report template with data, which reproduce the issue?

Thank you.

[Jennypi]

Hi,

I've managed to find a workaround with variables.

Concerning the example, just copy past my code in the "text" of a datamatrix component. I guess you will see what I got.

[HighAley]

Hello.

I've managed to find a workaround with variables.

It's a good news.

Concerning the example, just copy past my code in the "text" of a datamatrix component. I guess you will see what I got.

In the Design mode the expression is shown. So you get the wring data error and in the preview you will see the right value.

Thank you.