I figured out everything in my previous post thanks to everyone.
Here is my issue now.
I have this field PORel_Calc_ShipToAddrList.
I want to display it in the ship to field. But it only displays the first line. Here is the expression in the order of rows:
=split(Fields!PORel_Calc_ShipToAddrList.Value,“~”)(1).ToString()
=split(Fields!PORel_Calc_ShipToAddrList.Value,“~”)(2).ToString()
=split(Fields!PORel_Calc_ShipToAddrList.Value,“~”)(3).ToString()
=split(Fields!PORel_Calc_ShipToAddrList.Value,“~”)(4).ToString()
=split(Fields!PORel_Calc_ShipToAddrList.Value,“~”)(5).ToString()
So it should be showing all the rows. But it doesn’t.
When I change the expression to display the entire data, it shows all the data like it should. Expression would be:
=Fields!PORel_Calc_ShipToAddrList.Value
Example data:
John Doe~111 main st.~Miami, FL 11111~USA~~~
The data is there but it doesn’t want to display beyond the first name. What am I missing?
