topic Using a macro button to open an existing pdf. report ? in QlikView

Using a macro button to open an existing pdf. report ?

ivan_will — Sun, 24 Jan 2010 19:08:25 GMT

When I click on a button in a qlikview sheet , I want to open ana existing pdf report ? I think I should use macros , but don't have the macro codes for this operation !

Using a macro button to open an existing pdf. file ?

ivan_will — Sun, 24 Jan 2010 19:15:26 GMT

My idea is that some of the customers use qlikview via a browser! so they do not have the menu "reports" ! and need to use some reports that have been already created!

Using a macro button to open an existing pdf. report ?

Mon, 27 Feb 2012 09:21:53 GMT

Any reason why your not creating a text object, and then actions>add>external>launch?

Using a macro button to open an existing pdf. report ?

kamalqlik — Mon, 27 Feb 2012 09:58:54 GMT

Try to use this...

Hope this code help you

sub ReportCheck

set var = ActiveDocument.Variables("vCreatePDF")

val = var.GetContent.String

if val = 1 then

call CreateReports

var.SetContent 0, true

end if

End Sub

'***************************************************

'Functions creates the reports in PDF format

'***************************************************

sub CreateReports

tempFolder = "D:\DataPDF"

reportID = "RP01"

set rep = ActiveDocument.GetReport(reportID)

'set vShow = ActiveDocument.Variables("vShow")

'vShow.SetContent "on", true

reportName = rep.Name

'Create the file name with path

reportFile = tempFolder & "\" & reportID & "_" & reportName & ".pdf"

'print the report

printReportPDF reportID, tempFolder 'Call the function

'Rename the report

'checkOutputFile reportFile, tempFolder 'Call the function

'call ClearDefault() 'Call the function

end sub

'***************************************************

'Actual function to print the PDF format without being asked for location to save

'***************************************************

function printReportPDF(oReport, pdfLocation)

Set WSHShell = CreateObject("WScript.Shell")

WSHShell.RegWrite "HKCU\Software\CUSTPDF Writer\DefaultLocation", pdfLocation, "REG_SZ"

WSHShell.RegWrite "HKCU\Software\CUSTPDF Writer\UseJobName", "1", "REG_SZ"

WSHShell.RegWrite "HKCU\Software\CUSTPDF Writer\UseDefaultLocation", "1", "REG_SZ"

'QV Print

ActiveDocument.PrintReport oReport, "PDFCreator",false

set WSHShell = nothing

end function

and than create the

"I created a trigger OnOpen to run macro "ReportCheck"

Hope this help you.

Thanks and regards

Kamal

Re: Using a macro button to open an existing pdf. report ?

Thu, 11 Feb 2016 05:34:11 GMT

I wonder whether you have ever tried to convert pdf files into text? How about this one I found by Google? Any suggetsion will be appreciated. Thanks in advance.