Saving Complex Filtered Reports

I am using VB to automate filtering reports via complex filters then saving them. The problem is when I use VB to save these reports the filtered changes are lost. Has anyone experienced this? My code is as follows.

Set boApp = CreateObject(“BusinessObjects.Application”) Set boDoc = boApp.Documents.Open(DocString)

boApp.Visible = True
boApp.Interactive = False

Set vFilter = boApp.Variables.Item(“paramFilter”)

vFilter.Value = mvarPool
boApp.ActiveReport.ForceCompute

boDoc.Save

Thanks in advance,
Thom Susko


Listserv Archives (BOB member since 2002-06-25)

I am using VB to automate filtering reports via complex filters then saving
them. The problem is when I use VB to save these reports the filtered
changes are lost. Has anyone experienced this? My code is as follows.

Set boApp = CreateObject(“BusinessObjects.Application”)
Set boDoc = boApp.Documents.Open(DocString)

boApp.Visible = True
boApp.Interactive = False

Set vFilter = boApp.Variables.Item(“paramFilter”)

vFilter.Value = mvarPool
boApp.ActiveReport.ForceCompute

boDoc.Save

Thanks in advance,
Thom Susko


Listserv Archives (BOB member since 2002-06-25)

    Try the following:

    Instead of doing force compute on active report, do refresh
    on boDoc object as follows:

                      boDoc.Refresh

    Or try,        boDoc.Reports.Item(1).ForceCompute


    -- Vasan

I am using VB to automate filtering reports via complex filters then
saving
them. The problem is when I use VB to save these reports the filtered
changes are lost. Has anyone experienced this? My code is as follows.

Set boApp = CreateObject(“BusinessObjects.Application”)
Set boDoc = boApp.Documents.Open(DocString)

boApp.Visible = True
boApp.Interactive = False

Set vFilter = boApp.Variables.Item(“paramFilter”)

vFilter.Value = mvarPool
boApp.ActiveReport.ForceCompute

boDoc.Save

Thanks in advance,
Thom Susko


Listserv Archives (BOB member since 2002-06-25)