Anyone from QlickTech(/QV expert) please solve my issue,its urgent....

[#1]

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

[vidyut]

The Path mentioned is not accessible from the Client Machine, That is the reason.

[#3]

Hi ,

in the database for the path i am giving the server path.

Will you please tell me then what i am missing out?

Could you please send me some example for the same please, with implementing the macro?

please help me as i need it urgent.

(Note : I am using QV 8.5 and server 8.5 version).

Thanks,

Mahasweta

[#4]

Hi Vidyut,

I have one more macro here

--------------------------

Sub Absorption
'dim SelectedReportPath
set mySelections = ActiveDocument.fields("DESCRIPTION").GetPossibleValues
'Only if one selection is done
if mySelections.Count = 1 then
'Create one another button & keep it's Object ID as the one u specify next
SET doc = ActiveDocument
SET b = doc.GetSheetObject("BU01")
SET bp = b.GetProperties
bp.Application.v = "C:\Program Files\Internet Explorer\IEXPLORE.EXE"
'Now instead of FileName u can pass the URL that get's formed when u open the report in IE
'So in DB also u update the URL instead of FilePath
set URLName = ActiveDocument.fields("PATH").GetPossibleValues

'''In PATH variable u will pass URL

'bp.Parameters.v = "qvp://ukqkv02/darqmatter/innovation/Investment Performance (Innovation).QVW"
bp.Parameters.V = URLName.Item(0).Text
b.SetProperties bp
b.Press
End if
End Sub

---------

This is working fine in server, and the documents are opening ,but its opening in different browser,rather it has to open on the same browser.

Will you please tell me what to do for the same ?

Thanks,

Mahasweta