Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reports: Settings changed by macro

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

Labels (1)
3 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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