topic Reports: Settings changed by macro in QlikView

Reports: Settings changed by macro

Tue, 11 Jan 2011 16:22:01 GMT

Hi to all,

another question for today. Is there a possibility to change the settings from a report by macro (vbScribt) ?
As my function 'PrintReport' didn't take care about the before set bookmark (refer to my other request from today) , i was thinking about that, if I can set the bookmark to the Report with the help of vbScribt.

As i can read the (some) settings (e.g. ActiveDocument.GetReport("RP01").InitialSelection.BookmarkId), perhaps there's a way to set these option.

any ideas?

thanks & best regards

Stefan Bockelmann

AW:Reports: Settings changed by macro

Wed, 12 Jan 2011 10:36:37 GMT

Since I changed manually the option 'Initial Selection' from 'Clear All' to 'Current' in the Selections-Tab of the Report Settings,
the function 'PrintReport' works fine.

Nevertheless it would be of interest, if this option can be set by vbScribt (macro).

Best Regards

Stefan Bockelmann

AW:Reports: Settings changed by macro

Wed, 12 Jan 2011 11:07:13 GMT

Found this in the API guide which you might want to follow up:

set rep = ActiveDocument.GetReport("RP01")
set is = rep.InitialSelection
isbm = is.BookmarkId
ism = is.Mode

Regards,

Gordon

AW:Re: AW:Reports: Settings changed by macro

Wed, 12 Jan 2011 11:34:43 GMT

Hi Gordon, yes, I found this also.

I was "playing" a litle bit with this, and was able to get some report settings, but I didn't make it to overwrite the settings.

Thanks & best regards

Stefan