Report Designer and excel new lines in text field ignored
Posted: Sat 20 May 2017 07:36
Hi,
Just a quick question I have some text data that has been imported to my database from an excel spreadsheet that I want to include in a report using the Design New Report wizard. The problem I have is that the new lines in the text are stripped out so the text is not very readable. I have tried replacing the Char(10) for the new line in the text field but everything I have tried so far has not added the new lines back.
Can you let me know if there is a character to be used for new line in text used in the reports?
Just a quick question I have some text data that has been imported to my database from an excel spreadsheet that I want to include in a report using the Design New Report wizard. The problem I have is that the new lines in the text are stripped out so the text is not very readable. I have tried replacing the Char(10) for the new line in the text field but everything I have tried so far has not added the new lines back.
Can you let me know if there is a character to be used for new line in text used in the reports?