Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Need help printing a Qlikview report

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

7 Replies
Highlighted
Specialist
Specialist

Need help printing a Qlikview report

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.

Highlighted
Not applicable

Need help printing a Qlikview report

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





Highlighted
Specialist
Specialist

Need help printing a Qlikview report

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!!!

Highlighted
Not applicable

Need help printing a Qlikview report

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

Highlighted
Not applicable

Need help printing a Qlikview report

Hi

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


Highlighted
Not applicable

Need help printing a Qlikview report

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).

Highlighted
Not applicable

Need help printing a Qlikview report

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