views:

13

answers:

0

I have a report that displays beautifully onto the screen (print preview mode). If I try to export it to Word it works fine. If I try to do a PDF it fails. The field that causes the error is a multi-line field. If I filter our the TSQL code with

REPLACE(fieldName, CHAR(10), '') AS fieldName

everything works correctly but there are no longer line feeds at the appropriate spots. I've tried adding a replace in the VBScript of sqlrs to no avail. I've tried replacing with \r, \n, \r\n and CHAR(13) unsuccessfully as well.