Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
||Hi,
I want to have some action on button to reload report
I try 3 Macros
I) works only local but not in Acess Point
sub ReloadRep
ActiveDocument.Reload
end sub
||) Dont Work
sub Reload() | |
'Macro in Doc A | |
Dim WshShell | |
Set WshShell = CreateObject("WScript.Shell") | |
Set oExec = WshShell.Exec("C:\Program Files\QlikView\Qv.exe /r D:\Test Reload\ExternalReload.qvw") | |
Set WshShell = nothing | |
Set oExec = nothing | |
end sub III)Dont Work Sub External2 Set WSHShell = CreateObject("Wscript.Shell") WSHShell.Run("D:\Test Reload\reload.bat")
End Sub | |
Any Idea how to achieve goal and reload it on AP with macro?
Regards
Lukasz
To reload a document on the Server, schedule a task in the Management Console. With a trigger "on external event", you could launch a reload from another source than the Distribution Service.
Peter
Hi,
I set in management console
Start the task : On an external event.
In a list of tasks now I have start\schedule : On EDX.
but still when i click a butons with above macros - nothing happend.
Macros to initiate a reload and the Reload action are not supported on a QlikView server.
You can initiate a reload via an EDX task.
A) You can use the QMSEDX.exe to reload from the command line: QMSEDX Enhanced
B) You could use the QlikView extension that allow reload from the Ajax-client - although you should not allow
all or many users to do the reload. Google: Qlikblog.at and goto the site and find QlikTip #47.
Both these approaches use the QMS EDX task method - but you don't have to write your own program to use it.
Thank's
I'll try to use QMSEDX.exe
I test it by add an action in button
And when i test it by:
1) localy - QV - File --> Open in Server ( something reloaded)
2) on Acces point - after click on button i get new tabpage(about:blank)
You can never start an EXE-file (a program) from a browser. That would be a very very serious security risk and breach. So that has nothing to do with limitations of QlikView. You will have to use option B if you want to trigger a reload from a browser (QlikView Extension).