Export To PDF Loses VbCRLF Formatting

Hi



I've simplified this so I can test it's not me and so it's easier to explain.



I have one table in SQL server called Table1. Five fields called: One, Two, Three, Four, Five. Values of NULL, 2, 3, 4, NULL.



Reporting services, put a table in a report. Two fields. Header of Field1 and Field2.



Value field data for Field1 ="One: " & vbcrlf & "Two: " & vbcrlf & "Three: " & vbcrlf & "Four: " & vbcrlf & "Five: "



Value field data for Field2 =Fields!One.Value & vbcrlf & Fields!Two.Value & vbcrlf & Fields!Three.Value & vbcrlf & Fields!Four.Value & vbcrlf & Fields!Five.Value



Preview the report, all is well, you get this:

Field1 Field2
One:
Two: 2
Three: 3
Four: 4
Five:



Export it to a PDF, all is not well, I get this:
Field1 Field2
One: 2
Two: 3
Three: 4
Four:
Five:

I can make it work by checking the NULL fields and replacing them with a character. But why does it ignore the vbCRLF when exported to a PDF?

Any ideas...