I have a Report running on SQL 2005, say there are 2 fields I got from the database to show on the report:
(A) =Field!FullName.Value (defined as varchar(250) in database) (B) =Field!Description.Value (defined as nvarchar(max) in database)
When I export it to PDF, it shows up properly in Acrobat Reader. "FullName" (A) can be copied and pasted and also can be converted to Microsoft Word using 3rd party tools such as PDF to Word Converter. However, "Description" (B) can't - it shows as garbage characters.
Is there command or function that I can tell SQL 2005 PDF export to STOP using encoding?
THanks.