Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I've created a qvw with a straight table and added some dimensions and an expression on it. As one off my dimensions, I have a field with some big texts and it already has some line breaks (I'm referring to CHAR(10) and CHAR(13)), this line breaks were added into the SQL Server database (data source). When I'm looking on the data at the report everything looks good, but when I run a vbscript that exports this Straight Table as a pdf file, the line breaks disappear and I don't know why this is happening. Someone have any idea?
Here is a example of the data on report:
Dimension 1 | Dimension 2 | Expression |
---|---|---|
Example 1 | Some text; Some text; | 1 |
Example 2 | My text; My text; | 2 |
Example 3 | Anything; Anything; | 3 |
Here is how it looks after exporting to a pdf file (using vbscript):
Dimension 1 | Dimension 2 | Expression |
---|---|---|
Example 1 | Some text;Some text;Some text; | 1 |
Example 2 | My text;My text; | 2 |
Example 3 | Anything;Anything; | 3 |
Thanks in advance!
Best regards,
Tiago
I've tried two things: Copy to clipboard -> Image and Copy to clipboard -> Full table
When I copied as a Image it worked fine, but when I copied as a Full table It lost the line break. In my report I need to export as a full table because It's too big. I don't know if exists any difference between word 2007 and word 2010.
I've got it!
I used CHAR(11) instead of CHAR(10)+CHAR(13)
I think the problem was between the vbscript and word, it wasn't reckoning CHAR(10) + CHAR(13) as a line break, It does a line break with CHAR(11).
Thank you very much for your help and answering this question.
Best regards.