tag:blogger.com,1999:blog-3061477920752632671.post4855840765830348905..comments2022-12-12T03:26:30.955-08:00Comments on EPM Advice: Solution: Spaces removed when SSRS Report exported to PDFHammadhttp://www.blogger.com/profile/11585846491359871380noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-3061477920752632671.post-80312433519698287002014-10-29T03:06:06.247-07:002014-10-29T03:06:06.247-07:00Hi Vivek,
Yes this is the correct solution as des...Hi Vivek,<br /><br />Yes this is the correct solution as described in Martin's blog http://nearbaseline.com/blog/2014/07/ssrs-report-export-to-pdf-removes-spaces-from-text/Hammad Arifhttp://epmadvice.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-3061477920752632671.post-92141242120320060172014-10-29T02:31:40.004-07:002014-10-29T02:31:40.004-07:00Here is the solution :
SELECT REPLACE(ColumnName,...Here is the solution :<br /><br />SELECT REPLACE(ColumnName, NCHAR(8203), '') AS ColumnNameViveknoreply@blogger.comtag:blogger.com,1999:blog-3061477920752632671.post-90699556490612300452014-07-27T16:00:57.327-07:002014-07-27T16:00:57.327-07:00Hay thanks for this mate. Its always satisfying to...Hay thanks for this mate. Its always satisfying to find more cleaner explanation for the issues. isn't it :) <br />I have updated the blog with your findings.Hammad Arifhttp://epmadvice.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-3061477920752632671.post-62460236773542347032014-05-19T03:39:30.860-07:002014-05-19T03:39:30.860-07:00Hi - I have applied this solution to a report we h...Hi - I have applied this solution to a report we have in test - it works when selecting a single report and exporting to PDF however if more than one report (we have a parent report containing a sub report) is selected the logic seems to be ignored - some of the text is concatenated, the spaces are stripped and we get one long line of text. Any help appreciated..CDGnoreply@blogger.com