topic Re: Losing line break on generating a pdf using a vbscript in QlikView

Losing line break on generating a pdf using a vbscript

Mon, 17 Feb 2014 19:13:55 GMT

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; Some text;	1
Example 2	My text; My text;	2
Example 3	Anything; Anything;	3

Dimension 1

Dimension 2

Expression

Example 1

Some text;
Some text;

Some text;

Example 2

My text;

Example 3

Anything;

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

Re: Losing line break on generating a pdf using a vbscript

Anonymous — Mon, 17 Feb 2014 22:27:17 GMT

Have you tried something like this....

ActiveDocument.GetSheetObject("CH28").PrintEx "PDF-XChange 3.0",False

If that doesn't address the issue you have, could you load a sample of your script or a qv app that illustrates the problem?

Re: Losing line break on generating a pdf using a vbscript

Tue, 18 Feb 2014 20:13:57 GMT

I'm creating a word document first and then saving it as a pdf file. Something like this:

Const wdFormatPDF = 17

Set objWord = CreateObject("Word.Application")

objWord.visible = False

Set objDoc=objWord.Documents.add

Const wdOrientLandscape = 1

objDoc.PageSetup.Orientation = wdOrientLandscape

ActiveDocument.GetSheetObject("CH28").CopyBitmapToClipboard

objWord.Selection.Paste

objDoc.SaveAs "Sample.docx"

Set objDocument = objWord.Documents.Open("Sample.docx")

objWord.visible = False

objDocument.SaveAs "Sample.pdf", wdFormatPDF

Sorry for take too long to answer

Tiago

Re: Re: Losing line break on generating a pdf using a vbscript

Anonymous — Tue, 18 Feb 2014 21:05:43 GMT

Ok....I've created an example that appears to be working as intended.

Let me know if this helps.

Re: Losing line break on generating a pdf using a vbscript

Wed, 19 Feb 2014 11:40:58 GMT

I'm using personal edition... can you post the macro code?

Re: Losing line break on generating a pdf using a vbscript

Anonymous — Wed, 19 Feb 2014 14:09:31 GMT

This is what the chart I was exporting looked like.

here is the macro code:

Sub createPDF

Set XWord = CreateObject("Word.Application")

XWord.Visible=false

XWord.DisplayAlerts=false

Set DocWord = XWord.Documents.add()

Const wdFormatPDF = 17

Const wdOrientLandscape = 1

DocWord.PageSetup.Orientation = wdOrientLandscape

set image = ActiveDocument.GetSheetObject("CH02")

image.CopyBitmapToClipboard

XWord.Selection.Paste

DocWord.SaveAs "c:\Sample.pdf", wdFormatPDF

msgbox "File saved to C:\Sample.pdf"

'XWord.Quit

end sub

Re: Losing line break on generating a pdf using a vbscript

Wed, 19 Feb 2014 14:27:37 GMT

I removed the code below from my macro and now I'm saving directly as a pdf file like you did. I still have the same problem.

objDoc.SaveAs "Sample.docx"

Set objDocument = objWord.Documents.Open("Sample.docx")

objWord.visible = False

objDocument.SaveAs "Sample.pdf", wdFormatPDF

I added the line break by concatenating my texts with a CHAR(10) + CHAR(13)

How did you your line breaks?

Re: Losing line break on generating a pdf using a vbscript

Anonymous — Wed, 19 Feb 2014 14:51:47 GMT

I was using a calculated dimension since it was only a development app with sample data.

The calculated dimension was =repeat(members&';'&chr(13)&members&';',3)

What does the value look like in a list box object?

Re: Losing line break on generating a pdf using a vbscript

Wed, 19 Feb 2014 17:30:36 GMT

In a list box it looks equals in the straight table.

I've tried to do something like you did but nothing changed

What word version are you using? I'm using word 2007

Re: Losing line break on generating a pdf using a vbscript

Anonymous — Wed, 19 Feb 2014 18:40:39 GMT

I'm using word 2010....

Open an instance of Word. Right-click the chart object in QV and select copy to clipboard > Image. Go to your blank word doc and paste.

Does it work doing it manually as outlined above?

Re: Losing line break on generating a pdf using a vbscript

Wed, 19 Feb 2014 18:58:43 GMT

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.

Re: Losing line break on generating a pdf using a vbscript

Wed, 19 Feb 2014 19:15:48 GMT

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.