Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one Qv document from where i am calling other QV documents through macro.
And my macro is as below,
Sub Absorption
dim SelectedReportPath
set mySelections = ActiveDocument.fields("DESCRIPTION").GetPossibleValues
'Only if one selection is done
if mySelections.Count = 1 then
set FileName = ActiveDocument.fields("PATH").GetPossibleValues
SelectedReportPath = FileName.Item(0).text
Set App = ActiveDocument.GetApplication
Set newdoc = App.Opendoc (SelectedReportPath,"","")
newdoc.Activate
End if
End Sub
This one is working proper in Qlickview developer.
But when I am putting them in QV server its throwing one error, the error is " Macro parsing failed, the functionality was lost"?
Will some one please help me out saying what i am missing here?
Thanks In Advance,
Mahasweta
what is the operating system of your server ?
i have this error message for some macros when using qlikview server on a windows server 2008 machine
usually, macros generating this error on server also generates an error in qlikview developer on vista machine
Hi Jgeorge,
I have Windows server 2003 OS in my syatem?
Could you please suggest me now, what am missing here?
Thanks,
Mahasweta
Will please someone help me for this issue?
i need this urgent.
Thanks,
Mahasweta
Try putting messageboxes in it to see where it fails.
Sub Absorption
dim SelectedReportPath
set mySelections = ActiveDocument.fields("DESCRIPTION").GetPossibleValues
'Only if one selection is done
if mySelections.Count = 1 then
set FileName = ActiveDocument.fields("PATH").GetPossibleValues
msgbox("FileName= " & FileName)
SelectedReportPath = FileName.Item(0).text
msgbox("SelectedReportPath= " & SelectedReportPath)
Set App = ActiveDocument.GetApplication
msgbox("After GetApplication")
Set newdoc = App.Opendoc (SelectedReportPath,"","")
newdoc.Activate
msgbox("After Activate")
End if
End Sub
/Michael
The only time I have seen this error is when the client's ActiveX plug-in was an older version than the Developer and/or Server version.
Check your server settings. In server management console, go to QV server settings, security tab. There are two checkboxes for macros:
allow macro execution on server - you need this
allow macro execution on server - you don't need this for the macro in question, but maybe need for another macro.
Can't you just simply use the "Open QlikView Document" action from a button for example? The action is found under the External category.