Turns out this is a stroll in the park.
Simply create the string which should be processed by ExecuteBScript in the javascript, and pass this on the call i.e.
vBScriptCall = "process section root.'"+vQueryToProcess+"'"
Application.ExecuteBScript(vBScriptCall).
Assuming you are using Brio 6.5 or above, you should be able to use some Javascript on the Postprocess() method to apply the sort to the Pivot.
e.g.
ActiveDocument.Sections["Pivot"].SideLabels["Dummy"].SortByLabel(bqSortAscend)
All,
I'm trying to use:
Application.ExecuteBScript("process section root.'Query'")
to process from an EIS screen, however I have prototyped this and it seems that I need to hardcode the query section name. Does anyone know if i can use variables in this? (i have over 50 query...
Hi,
I have a series of Brio documents which are contain a 'Build Query' EIS screen used for generating queries by users of my system. The users need to be able to save these files locally, saving any limits, formatting charts etc that they may have created. They also need to be able to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.