more quick actions
minimize quick actions
Topic starter
Hello,
Normally when a report is generated by Dream Report based on a trigger from PcVue, the report is automatically open in Adobe PDF viewer. PcVue users then have access to all the menus of Adobe PDF Viewer. Users can also save a copy of the generated report on any other location of their choice and also can rename the report. The customer doesn't want to give this access to the PcVue operator. Operators Should only able to generate, view and print the report.
We tried to find a PDF viewer or ActiveX control which will only have a view and print option we didn't found anything. Can anybody suggest a solution to achieve this requirement?
Thanks & Regards,
Nitesh Dongare
Posted : 03/05/2021 7:00 pm
Posted : 03/05/2021 8:30 pm
Hello Nitesh,
Please can you try with the pdf parameters in your report settings and tell us back if these options can fit your need?
Posted : 03/05/2021 10:15 pm
Topic starter
There are two issues in using pdf parameters.
1. To view the report user needs to enter the password and this password will be common for all the PcVue users and I should satisfy 21CFR11 password requirements like password expiry, aging, etc. . Which is not possible with DR.
2. After entering a good password user can rename the file which is also not expected.
TR,
Nitesh Dongare
Posted : 04/05/2021 12:18 pm
Topic starter
Hello Nico,
PDF Xchange ActiveX control satisfies the requirements but this product is not open source and also discontinued by the manufacturer and not available for sale.
If I use in demo version it shows a big red-colored watermark.
It will be good if I can find similar activeX but open source.
Thanks & Regards,
Nitesh Dongare
Posted : 04/05/2021 1:57 pm
Hello all,
We could actually make use of Acrobat Reader DC ActiveX in PcVue Mimic to serve as PDF reader, as shown in Advanced Training Module 28. By adding this parameter
#toolbar=0
at the end of the file name, then the viewer will not have any toolbar, so the user can only view the PDF and cannot modify or save it. Credits to Andy Tan for finding this.
Nitesh also needed to allow the customer to print the PDF also, so I found https://www.access-programmers.co.uk/forums/threads/vba-code-to-print-an-existing-pdf-file.287501/ , in which we can pass the PDF file name and it will print to the default system printer (Refer to the last code). So we can also add a button in the same mimic which displays the PDF, and when clicked, it will print the PDF in the printer.
Public Sub PrintAnyDocument(ByVal strPathFile As String)
Dim TargetFolder
Dim FileName
Dim ObjShell As Object
Dim ObjFolder As Object
Dim ObjItem As Object
Dim ColItems As Object
If InStrRev(strPathFile, "") 0 Then
TargetFolder = Left(strPathFile, InStrRev(strPathFile, ""))
FileName = Right(strPathFile, Len(strPathFile) - Len(TargetFolder))
End If
Set ObjShell = CreateObject("Shell.Application")
Set ObjFolder = ObjShell.NameSpace(TargetFolder)
Set ColItems = ObjFolder.Items
For Each ObjItem In ColItems
If ObjItem.Name = FileName Then
ObjItem.InvokeVerbEx ("Print")
Exit For
End If
Next
Set ObjItem = Nothing
Set ColItems = Nothing
Set ObjFolder = Nothing
Set ObjShell = Nothing
End Sub
Thanks,
Kantha
Posted : 05/05/2021 12:19 pm