topic Re: How to create a pdf file for the active sheet? in QlikView

How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 05:20:02 GMT

Hi all,

How to create a pdf file for the active sheet including all corresponding sheet objects.

If it is possible,

Please let me know your responses on this post.

Thanks in advance for any quick response.

Regards

Kumar

Re: How to create a pdf file for the active sheet?

Siva_Sankar — Fri, 28 Dec 2012 05:29:50 GMT

Are you tryint to export the sheet objects to pdf?

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 05:30:03 GMT

in your script write this code.

STORE Sheet1 into ;

here sheet1 is table name.

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 06:42:40 GMT

Hi Vishwaranjan,

I need a macro to export the active sheet (Including corresponding sheet objects in that sheet) from UI.

Thanks for the response

Regards

Kumar

Re: How to create a pdf file for the active sheet?

Siva_Sankar — Fri, 28 Dec 2012 06:46:19 GMT

refer the following link,it will help. http://community.qlik.com/message/126410#126410 Regards. Siva Sankar K

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 07:57:06 GMT

use it

sub pdf

printReportPDF "C:\Test\test28.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "Report1", "QlikviewPDF"

ActiveDocument.GetApplication.Sleep 10000

end sub

hope it helps you

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 08:30:38 GMT

Hi Viswaranjan,

Can you please attach a sample file.

Regards

Kumar

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 09:02:36 GMT

hi try it

sub pdf

printReportPDF "C:\Test\test28.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "Report1", "QlikviewPDF"

ActiveDocument.GetApplication.Sleep 10000

end sub

Function printReportPDF(pdfOutputFile)

Set WSHShell = CreateObject("WScript.Shell")

WSHShell.RegWrite "HKCU\Software\QlikviewPDF\OutputFile", pdfOutputFile, "REG_SZ"

WSHShell.RegWrite "HKCU\Software\QlikviewPDF\BypassSaveAs", "1", "REG_SZ"

Set WSHShell = nothing

End function

*********************************

then allowing system access in macro and on sheet press ctri+shift+M there choose system access.

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 09:24:25 GMT

Vishwaranjan,

if we create the report manually then that report will export as a pdf file and it is fine.I have already worked like that.

I have tried like by taking the scrrenshot of the sheet and create a report with that image manually and finally the pdf file is missing the clarity of the actual image.

But how to create the document report dynamically with activesheet(whole sheet including all objects) just like an image.

I am expecting any help on this one.

Regards

Kumar

Re: How to create a pdf file for the active sheet?

Fri, 28 Dec 2012 11:17:13 GMT

see the attached file

hope this helps you.

Re: How to create a pdf file for the active sheet?

Sun, 14 Apr 2013 19:00:03 GMT

Hi Kumar,

I know that have been posting this question a while ago, but given that I am facing the same issue - did you find a solution?

I'd like to print out all the active objects in my sheet as well, but not by creating a pfd-report.

Kind regards

Urs