Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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