topic Re: QlikView reports PDF export in QlikView

QlikView reports PDF export

mohamed_ahid — Tue, 12 Nov 2013 15:22:43 GMT

Hi ,

can we do reports PDF export on QlikView sheets? How ?

Thx

Re: QlikView reports PDF export

datanibbler — Tue, 12 Nov 2013 15:27:58 GMT

Hi,

sure you can. There is a main_menu item "Reports" - you can use that to create one or several reports based on your qvw - using the same objects by just dragging them onto the report_page (so it's a good idea to create a kind of "workroom" in your qvw where you assemble all the objects to use in your report).

You can even set the selections that should be made whenever one of your reports is triggered.

HTH

Best regards,

DataNibbler

Re: QlikView reports PDF export

mohamed_ahid — Tue, 12 Nov 2013 15:38:54 GMT

Thx DataNibbler,

and how can i do a pdf export within a button ?

Re: QlikView reports PDF export

datanibbler — Tue, 12 Nov 2013 15:43:34 GMT

Hi,

once your report is created, I think you can trigger the printing of the export on a button - it's under the action_category "external".

If you have a pdf_printer, send the report to be printed by that and you will have your pdf - I don't know if the printing_dialog will still pop up then, I've never actually done that, but I guess you can set the printer to just work with some default settings and ask no questions...

Re: QlikView reports PDF export

mohamed_ahid — Wed, 13 Nov 2013 09:42:18 GMT

its understood that all user have to get the pdf_printer installed on their machine ; which is not sure in my case .

may be another solution ?

Re: QlikView reports PDF export

datanibbler — Wed, 13 Nov 2013 09:59:12 GMT

Hi Mohamed,

I'm not aware of any other solution. You might create a macro, but that would have to be pretty complex

- Short form: If you want a pdf, there's no way around some tool that creates pdf files 😉

<=> Another solution might be the Publisher+Add-on (somewhere around €30k) that can then automatically trigger reports, make them into pdf files and send them round - OR another tool that does the same for a fraction (look for "ReportToMail")

Best regards,

DataNibbler

Re: QlikView reports PDF export

mohamed_ahid — Wed, 13 Nov 2013 10:06:39 GMT

Thx DataNibbler .

Re: QlikView reports PDF export

mohamed_ahid — Thu, 14 Nov 2013 14:40:04 GMT

So i tried to do that after installing a pdf_printer driver .

i proceed like this :

-create a report .

-create a macro :

Sub SendReport

ActiveDocument.PrintReport("RP01"),"Bullzip PDF Printer",false

End sub

-add button with macro execute action

but still not working , when i click on the button i get the macro window .

any help please .

Re: QlikView reports PDF export

jerrysvensson — Thu, 14 Nov 2013 15:02:30 GMT

If you search the forum for Bullzip you will find a lot code to this.

Re: QlikView reports PDF export

Thu, 08 Jan 2015 00:16:40 GMT

Create a report in QVW (go to Reports > Edit Reports...). Click Add, then give name of the new report. Click Edit and drag objects over from your QVW on to the report. You can use banding to cycle through dim values, etc.

Once done, you can add a button on your sheet with the action type of "Print Report". For Report ID, specify from the earlier step...it will be called something like RP01 for your first report. No macros required here. This allows users to obtain PDFs on they fly.

Re: QlikView reports PDF export

afurtado — Thu, 08 Jan 2015 00:43:54 GMT

Hi. This is a model sample that send pdf by email. You need a pdfcreator or another pdf printer.

Using macro is not a good thing. Have same post about it (bad performance,clear cache,....... )

Also, have some products to do it (e.g. QVMail / NPrinting ).

Best,

Alessandro Furtado

Re: QlikView reports PDF export

afurtado — Thu, 08 Jan 2015 00:51:20 GMT

this sample is just to save a pdf (I use pdfcreator to save automatic).

Re: QlikView reports PDF export

gizzel123 — Mon, 06 Apr 2015 10:48:16 GMT

Loved this approach

Re: QlikView reports PDF export

daveatkins — Tue, 11 Aug 2015 14:56:05 GMT

One thing you can do...if you have the qlikview reports on a web server, load the report through the web browser, then you will be able to save that screen to PDF--at least for Chrome.