topic Need help printing a Qlikview report in QlikView

Need help printing a Qlikview report

Wed, 26 May 2010 14:32:56 GMT

Hi Everyone,

I am a relatively new Qlikview user and would like some help printing a Qlikview report (or exporting it to a PDF file ideally). My Qlikview file consists of a sheet with list and graph objects.

What I want to do is print a particular sheet but with different bookmarks. For example, let's suppose I have 3 bookmarks corresponding to three sets of selections. What I want in the end is a 3 page PDF file of the same sheet, where each page corresponds to a different bookmark (or set of selections).

If it helps, I am using Qlikview 9.

Regards,

Iaroslav

Need help printing a Qlikview report

boorgura — Wed, 26 May 2010 15:09:13 GMT

If you need a same sheet to be printed 3 times with different selections,

I would assume the only possibility is to have a macro - which defines the selections followed by a print to pdf statement for the same report.

Let me know if you have any questions.

Actually we use the same approach.

Need help printing a Qlikview report

Wed, 26 May 2010 15:39:27 GMT

Hi Rocky,

Thank you for your reply. How would I exactly go about writing a macro to print to pdf? So far I have a macro that goes through my bookmarks and saves the .bmp files which I then convert to PDF. Is it possible to crease a .pdf file and then append all other images to it from a macro?

Thanks,

Iaroslav

Need help printing a Qlikview report

boorgura — Wed, 26 May 2010 16:10:26 GMT

A sample of how the macro would be:

Sub PrintToPDFSummary

SummaryDefaultViewSelection()
ActiveDocument.PrintReport "RP32", "PDFCreator"
ActiveDocument.ClearAll

SummaryDefaultView2Selection()
ActiveDocument.PrintReport "RP32", "PDFCreator"
ActiveDocument.ClearAll

end Sub

The above example shows how to call 2 macros which will trigger different selections on the same report.

WE use a software called PDFCreator to generate PDF files. If I'm not wrong it should be an open-source one. there are a couple of other options as well.

Let me know if you have any other questions!!!

Need help printing a Qlikview report

Wed, 26 May 2010 17:08:33 GMT

Thanks for the help Rocky. What you suggested work. However, is there a way to print a sheet (no report) using a macro? I've been looking on the web to see how to do so, but I cannot find anything.

Thanks,

Iaroslav

Need help printing a Qlikview report

Wed, 26 May 2010 17:20:34 GMT

I use the following macro to print a sheet, bear in mind that that's exactly what it does, it takes a screen dump of the entire active sheet, opens up MS-Word, pastes the screen capture into word, prints it and then dumps the document. It works perfectly for me because it does exactly what we want....

SUB mcr_PrintActiveSheet
 Set objWord = CreateObject("Word.Application")
 objWord.Visible = False
 Set objDoc = objWord.Documents.Add
 Const wdOrientLandscape = 1
 objDoc.PageSetup.Orientation = wdOrientLandscape
 ActiveDocument.ActiveSheet.CopyBitmapToClipboard false
 objWord.Selection.Paste
 Const wdAlignParagraphCenter = 1
 objDoc.Paragraphs(1).Alignment = wdAlignParagraphCenter
 objDoc.PrintOut()
 DO WHILE objWord.BackgroundPrintingStatus > 0
 LOOP
 objWord.Quit wdDoNotSaveChanges
 Set objWord = Nothing
 Set objDoc = Nothing
END SUB

Need help printing a Qlikview report

Wed, 26 May 2010 17:23:32 GMT

By the way, if you are using V9 then all of the above can be replaced using Actions against a button, which would be much better as it will also offer you the choice of providing a print dialogue window (to select the printer) which my macro doesn't do (it will print only to the default printer).

Need help printing a Qlikview report

Thu, 27 May 2010 07:54:52 GMT

Dear All

I have one question?

how can fetch whole sheet in pdf format with the help of macro

then i send auto mail whole sheet to everybody daily basic .

Please help me very very urgent basic ..

very.......................................urgent

Regards

Ashish