Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
can we do reports PDF export on QlikView sheets? How ?
Thx
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
Thx DataNibbler,
and how can i do a pdf export within a button ?
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...
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 ?
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
Thx DataNibbler .
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 .
If you search the forum for Bullzip you will find a lot code to this.
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.