topic Re: Print Sheet Button not working in Access Point in QlikView

Print Sheet Button not working in Access Point

gizzel123 — Mon, 06 Apr 2015 11:39:41 GMT

Hi All,

I have added a Print sheet Button with the action : " Print Sheet".

But it it not working in Access Point.

Please help me out.

Thanks.

Re: Print Sheet Button not working in Access Point

ashfaq_haseeb — Mon, 06 Apr 2015 11:43:34 GMT

Hi,

This is known thing it will not work in AJAX client.

Why not go with screenshot extension instead.

Re: Print Button not working on server

Regards

ASHFAQ

Re: Print Sheet Button not working in Access Point

buzzy996 — Mon, 06 Apr 2015 11:54:08 GMT

it's work with desktop but ajax plugin won't support ..if u need u have to use IE plugin for this.

Re: Print Sheet Button not working in Access Point

Mon, 06 Apr 2015 12:06:31 GMT

hi Gizzel,

try this code....

'***************************************************'Functions creates the reports in PDF format'***************************************************sub CreateReports tempFolder = "C:\Temp" reportID = "RP01" reportName = reportID'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 functionend 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

Re: Print Sheet Button not working in Access Point

Mon, 06 Apr 2015 12:08:27 GMT

Hi Gizzel,

Print sheet on Ajax client is not supported. You must use IE plug-in for that functionality. If Ajax client is the default client on your company, the only workaround is using the browser print options. You can read more at the help are on developer, this is what describes about it:

" Print Sheet: Prints the sheet specified by Sheet ID. (Not available as document and sheet trigger.) This function does not work in AJAX client. "