Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

macro execution does not work after reloading through scheduler in QV 11

Hi,

I have written a macro to create pdf after reloading is done.

This works fine if the report is reloaded through QV Desktop.

but when the same report is reloaded through QV server using scheduler, reloading works fine but pdf does not get generated.

This is the macro I have written in Edit module and have triggered it on PostReload.

sub PrintReport

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP01", "PDF-Xchange 4.0", false ' This line of code pops up save as dlg

ActiveDocument.GetApplication.Sleep 10000

end sub

ea

12 Replies
Not applicable
Author

Hi Apu,

I also try to export sheet imageafter reloading. Will you please send me your batch file which worked for you?

Thanks

Not applicable
Author

Hi,

follow the below steps to create a batch file:

1. open notepad.

2. write statement as - "C:\Program Files\QlikView\Qv.exe" "E:\Documents\Sales.qvw"

     1st parameter is the location of the qlikview software and

     2nd parameter is the location of qvw file.

3. save the file with the name as test.bat

4. close the file.

To test

1. double click the batch file.

This will open the qvw file.

Hope this helps you.

Anonymous
Not applicable
Author

Hello I have a similar problem maybe smb can answer this thread

http://community.qlik.com/thread/97887

Thx

chesterluck